Gett interview question

SQL queries, computer science problems