Pergunta de entrevista da empresa Zynga

Q: There was another SQL question on Coderpad but we ran out of time. Seemed like simple aggregation and joins.