FIGmd interview question

sql basic questions and tables, join