Flatiron Health Interview Question

SQL query question involving inner joins and group by.