Pergunta de entrevista da empresa Prometheus Group

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