Pregunta de entrevista de Amazon

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