FREE AI-Enhanced Online SQL Server Compiler

Untitled*

You must execute the code again to save those values in the database.

CREATE TABLE Products (
    ID INT PRIMARY KEY,
    Name VARCHAR(100),
    Quantity INT
);

CREATE TABLE SalesOrderItems (
    OrderID INT PRIMARY KEY,
    ProductID INT,
    OrderDate DATE,
    QuantityOrdered INT,
    FOREIGN KEY (ProductID) REFERENCES Products(ID)
);

INSERT INTO Products (ID, Name, Quantity) VALUES 
(1, 'Laptop', 50),
(2, 'Mouse', 10),
(3, 'Keyboard', 5),
(4, 'Monitor', 30),
(5, 'Headphones', 15),
(6, 'Webcam', 8),
(7, 'USB Cable', 100),
(8, 'External Hard Drive', 12),
(9, 'Gaming Mousepad', 18),
(10, 'Smartphone', 25);

INSERT INTO SalesOrderItems (OrderID, ProductID, OrderDate, QuantityOrdered) VALUES 
(101, 2, '2024-02-01', 2),
(102, 3, '2024-02-02', 1),
(103, 5, '2024-02-03', 3),
(104, 6, '2024-02-04', 5),
(105, 8, '2024-02-05', 2),
(106, 9, '2024-02-06', 4),
(107, 1, '2024-02-07', 1),
(108, 4, '2024-02-08', 2),
(109, 10, '2024-02-09', 3),
(110, 7, '2024-02-10', 1);

/*SELECT * 
FROM SalesOrderItems 
WHERE ProductID IN (
    SELECT ID 
    FROM Products 
    WHERE Quantity < 20
);
*/

SELECT  s.* 
FROM SalesOrderItems s
JOIN Products p ON s.ProductID = p.ID
WHERE p.Quantity < 20;

OrderID	ProductID	OrderDate	QuantityOrdered
101	2	2024-02-01	2
102	3	2024-02-02	1
103	5	2024-02-03	3
104	6	2024-02-04	5
105	8	2024-02-05	2
106	9	2024-02-06	4

(10 rows affected)

(10 rows affected)

(6 rows affected)