Guidehouse interview question

Mostly on sql queries including the joins