Michigan Mutual interview question

Basic to intermediate sql query design