Write a SELECT statement that returns the same result set as this SELECT statement, but don’t use a join. Instead, use a subquer
y in a WHERE clause that uses the IN keyword. SELECT DISTINCT category_name FROM categories c JOIN products p ON c.category_id = p.category_id ORDER BY category_name
SELECT DISTINCT category_name FROM categories c WHERE category_id IN (SELECT category_id FROM products)
Please refer to the explanation below.
Explanation:
This question is testing your knowledge on the database querying language to retrieve rows of data from the database. A fast way to retrieve data from the SQL database is by using a join if more than one table is being queried, since there is a direct link to the table. We can also write the statement instead with a sub-query included in the where clause to specify the filter conditions:
SELECT DISTINCT category_name FROM categories c WHERE category_id IN (SELECT category_id FROM products)
