Amazon interview question

Intermidiate level SQL queries which involved aggregation, joins, date, sub queries