Domanda di colloquio di Citizen (NY)

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