Novartis interview question

Writing an SQL query on the spot