Amazon Interview Question

Gives a data schema, asks how you would code the solution in SQL. Aggregations tested, joins lightly tested, window function.