Citizen (NY) Interview Question

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