For these exercises, you must return only the rows and columns specified. Including anything beyond the minimal set that satisfies the question is an error!

It is possible that you have a slightly different row count than I do and are still correct.

#1

The following table join returns a list of the vendorNames who have at least one corresponding entry in the invoices table:

SELECT DISTINCT vendorName

FROM vendors AS v INNER JOIN invoices AS i

ON v. vendorID = i. vendorID

ORDER BY vendorName;

Write a similar statement that returns the same rows and columns; however, use a subquery in a WHERE clause instead of the inner join.