SQL PRACTICE QUERIES WITH ANSWERS
Table: CUSTOMERS
INSERT INTO Customers (CustomerID, Name, Email, City) VALUES (1, 'Alice Smith',
'alice@example.com', 'New York');
INSERT INTO Customers (CustomerID, Name, Email, City) VALUES (2, 'Bob Johnson',
'bob@example.com', 'Chicago');
UPDATE Customers SET City = 'Los Angeles' WHERE CustomerID = 2;
DELETE FROM Customers WHERE CustomerID = 1;
SELECT * FROM Customers;
SELECT Name FROM Customers WHERE City = 'Chicago';
SELECT COUNT(*) FROM Customers;
SELECT DISTINCT City FROM Customers;
SELECT * FROM Customers WHERE Email LIKE '%@example.com';
SELECT * FROM Customers ORDER BY Name ASC;
SELECT * FROM Customers WHERE CustomerID IN (1, 2);
SELECT * FROM Customers WHERE City IS NOT NULL;
SELECT Name, City FROM Customers WHERE City <> 'Boston';
UPDATE Customers SET Email = 'updated@example.com' WHERE Name = 'Bob Johnson';
DELETE FROM Customers WHERE Name LIKE 'A%';
SQL PRACTICE QUERIES WITH ANSWERS
Table: ORDERS
INSERT INTO Orders (OrderID, CustomerID, OrderDate, Amount) VALUES (101, 2,
'2024-01-15', 250.75);
INSERT INTO Orders (OrderID, CustomerID, OrderDate, Amount) VALUES (102, 2,
'2024-02-10', 300.50);
SELECT * FROM Orders;
SELECT * FROM Orders WHERE CustomerID = 2;
UPDATE Orders SET Amount = 275.00 WHERE OrderID = 101;
DELETE FROM Orders WHERE Amount < 200;
SELECT AVG(Amount) FROM Orders;
SELECT MAX(Amount) FROM Orders;
SELECT MIN(OrderDate) FROM Orders;
SELECT COUNT(DISTINCT CustomerID) FROM Orders;
SELECT CustomerID, SUM(Amount) FROM Orders GROUP BY CustomerID;
SELECT * FROM Orders WHERE OrderDate BETWEEN '2024-01-01' AND '2024-03-01';
SELECT * FROM Orders WHERE Amount > 100 ORDER BY Amount DESC;
UPDATE Orders SET OrderDate = CURRENT_DATE WHERE OrderID = 102;
DELETE FROM Orders WHERE OrderID = 999;
SQL PRACTICE QUERIES WITH ANSWERS
Table: PRODUCTS
INSERT INTO Products (ProductID, Name, Price, Stock) VALUES (201, 'Laptop', 999.99, 10);
INSERT INTO Products (ProductID, Name, Price, Stock) VALUES (202, 'Mouse', 25.50, 100);
SELECT * FROM Products;
SELECT Name FROM Products WHERE Price > 50;
UPDATE Products SET Stock = Stock - 1 WHERE ProductID = 202;
DELETE FROM Products WHERE Stock = 0;
SELECT COUNT(*) FROM Products;
SELECT AVG(Price) FROM Products;
SELECT * FROM Products ORDER BY Price DESC;
SELECT * FROM Products WHERE Name LIKE '%top%';
SELECT * FROM Products WHERE ProductID BETWEEN 200 AND 300;
UPDATE Products SET Price = Price * 1.1 WHERE Name = 'Laptop';
DELETE FROM Products WHERE ProductID = 999;
SELECT MAX(Stock) FROM Products;
SELECT ProductID, Price * Stock AS InventoryValue FROM Products;
