Write a SELECT statement that returns the same result set as this SELECT statement, but don’t use a join. Instead, use a subquery 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

Hi there! The answer to this question is:

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)

the correct answer is "part of speech" if the portion used is "verb, noun" there is another question similar to this with the same question but different portion. the other portion is "hand write" and the correct component for that question is "antonym".

hope this . : )