Pergunta de entrevista da empresa Citizen (NY)

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