Ejada interview question

write some SQL queries to solve some problems