Deloitte SQL Interview Problem - Level Hard

Deloitte SQL Interview Problem - Level Hard Script

DROP TABLE IF EXISTS Products;

CREATE TABLE Products (
ProductID INT PRIMARY KEY,
Product VARCHAR(255),
Category VARCHAR(100)
);

INSERT INTO Products (ProductID, Product, Category)
VALUES
(1, 'Laptop', 'Electronics'),
(2, 'Smartphone', 'Electronics'),
(3, 'Tablet', 'Electronics'),
(4, 'Headphones', 'Accessories'),
(5, 'Smartwatch', 'Accessories'),
(6, 'Keyboard', 'Accessories'),
(7, 'Mouse', 'Accessories'),
(8, 'Monitor', 'Accessories'),
(9, 'Printer', 'Electronics');