Citizen (NY) interview question

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