Pergunta de entrevista da empresa Hinge

Pretty straight-forward SQL, joining across 2-3 tables and leveraging aggregates