Michigan Mutual Interview Question

Basic to intermediate sql query design