Gapblue interview question

sql queries mainly from JOIN queries