Inferenz interview question

Sql questions, joins, aggregate functions