SQL Query: Find products that never were ordered Using NOT EXISTS (Step-by-Step)

CREATE TABLE products (
product_id INT PRIMARY KEY,
product_name VARCHAR(100),
price DECIMAL(10,2)
);

CREATE TABLE order_details (

order_id INT,
product_id INT,
quantity INT
);

-- 2. Insert some sample products

INSERT INTO products (product_id, product_name, price) VALUES
(1, 'Laptop', 999.99),
(2, 'Smartphone', 699.99),
(3, 'Headphones', 149.99),
(4, 'Tablet', 399.99),
(5, 'Smartwatch', 199.99),
(6, 'Keyboard', 49.99);

-- 3. Insert some sample orders — note not all products are ordered

INSERT INTO order_details (order_id, product_id, quantity) VALUES
(101, 1, 2), -- Laptop ordered
(102, 2, 1), -- Smartphone ordered
(103, 1, 1), -- Laptop ordered again
(104, 4, 3), -- Tablet ordered
(105, 2, 2); -- Smartphone ordered again

-- So: products with product_id 3 (Headphones), 5 (Smartwatch), 6 (Keyboard) never ordered.
TABLE products (
product_id INT PRIMARY KEY,
product_name VARCHAR(100),
price DECIMAL(10,2)
);

CREATE TABLE order_details (

order_id INT,
product_id INT,
quantity INT
);

-- 2. Insert some sample products

INSERT INTO products (product_id, product_name, price) VALUES
(1, 'Laptop', 999.99),
(2, 'Smartphone', 699.99),
(3, 'Headphones', 149.99),
(4, 'Tablet', 399.99),
(5, 'Smartwatch', 199.99),
(6, 'Keyboard', 49.99);

-- 3. Insert some sample orders — note not all products are ordered

INSERT INTO order_details (order_id, product_id, quantity) VALUES
(101, 1, 2), -- Laptop ordered
(102, 2, 1), -- Smartphone ordered
(103, 1, 1), -- Laptop ordered again
(104, 4, 3), -- Tablet ordered
(105, 2, 2); -- Smartphone ordered again

-- So: products with product_id 3 (Headphones), 5 (Smartwatch), 6 (Keyboard) never ordered.



➤SQL Tutorials in Telugu:    • SQL Tutorials in Telugu  

➤ Join our Facebook group:
  / 206746378741662  
➤ Join our WhatsApp group:
https://chat.whatsapp.com/JXrRh9IX0Gu...

Subscribe Now and Stay Updated! 🔔
► Contact: +91-8142550075