Gapblue Interview Question

sql queries mainly from JOIN queries