Seize Consulting interview question

Basic questions of SQL Joins etc