Allstate Interview Question

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