All pastes #2121620 Raw Edit

Anonymous

public text v1 · immutable
#2121620 ·published 2012-02-26 05:20 UTC
rendered paste body
Show the list of interns and all of the companies that they have interned at. The report should have their first and last names and the company name. Order by the company name starting with Z. Remember, some interns have worked at more than one place! Hint: So you don’t have an entry for each hour, use the DISTINCT command. Also, you will need to access three tables for this query