79668412

Date: 2025-06-17 02:40:28
Score: 1
Natty:
Report link

Another solution could be:

SELECT
    COUNT(DISTINCT products_never_sold)*100.0/ COUNT(DISTINCT product_category) AS pct_product_categories_never_sold
FROM (

    SELECT
        product_category
        , (CASE WHEN SUM(units_sold) IS NULL THEN product_category END) AS products_never_sold
    FROM product_classes pc
    LEFT JOIN products p
        ON pc.product_class_id = p.product_class_id
    LEFT JOIN sales s
        ON s.product_id = p.product_id
    GROUP BY 1

)
Reasons:
  • Has code block (-0.5):
  • Unregistered user (0.5):
  • Low reputation (1):
Posted by: cloudy_jay