UK Biobank interview question

SQL joins, chosen language syntax, some multiple choice, writing queries