AstraZeneca interview question

SQL queries and DW concepts