Critical TechWorks interview question

They asked me to do a SQL query using join