Write a SELECT statement that returns the same result set as this SELECT statement, but dont use a join. Instead, use a subquery in a WHERE clause that uses the IN keyword.

SELECT DISTINCT vendor_name

FROM vendors JOIN invoices

ON vendors.vendor_id = invoices.vendor_id

ORDER BY vendor_name;