Pergunta de entrevista da empresa Flatiron Health

SQL query question involving inner joins and group by.