Pregunta de entrevista de Citizen (NY)

Use case SQL-query question using CTEs, joins, aggregations.