Domanda di colloquio di Allstate

SQL question on a table join with summary functions: count, AVG