Prometheus Group Interview Question

Given a database structure, write various SQL statements to give certain results (tested knowledge of SELECT and different types of JOINs).