Advantmed interview question

SQL queries for select statement ?