my-guitar-shop-database-exersices/Exercise_2.6.sql

SELECT 
    c.category_name, p.product_id
FROM
    categories c
        LEFT OUTER JOIN
    products p ON c.category_id = p.category_id
WHERE
    p.product_id IS NULL
ORDER BY c.category_name DESC;