Pergunta de entrevista da empresa Hamilton Group

Two SQL questions (Postgres or SQLite only, no MySQL). You'd need to know how to sum columns, reference foreign keys, do joins etc.