inPowered AI interview question

SQL query on purely normalized table