contestada

Write a SELECT statement that returns the category_name column from the Categories table. Return one row for each category that has never been assigned to any product in the Products table. To do that, use a subquery introduced with the NOT EXISTS operator.

Respuesta :

Answer:

Below is the required statement:

Explanation:

select c.categoryname

from categories c

where not exists (select 1 from products p where p.categoryid = c.categoryid);

Otras preguntas