CREATE TABLE Ref_colors (color_code VARCHAR)
CREATE TABLE products (color_code VARCHAR)

How many colors are never used by any product?
SELECT COUNT(*) FROM Ref_colors WHERE NOT color_code IN (SELECT color_code FROM products)
SELECT COUNT(*) FROM "Ref_colors" WHERE NOT "color_code" IN (SELECT "color_code" FROM "products")