Homework 1 Clarifications

· 1(c) It is okay to have ABC Co. as part of your result.

· 1(f) For each company, find the highest salaried employees.

· 2(d) The pair (i, i) should not be a pair of company names in the result.

· 2(e) Do not worry about duplicate company names in the result. It is okay for your SQL statement to print out duplicate names.

· 2(f) Ignore this question. We have not covered the material in the class yet. If you are interested, you can look up the "ALL" and "MAX" operators to handle this query.