SELECT * FROM orders;

SELECT OrderID, CustomerID FROM orders;

SELECT * FROM orders WHERE OrderDate > "1997-01-01";

SELECT CustomerID, COUNT(*) FROM orders GROUP BY CustomerID;

DELETE FROM Orders WHERE OrderID = 10;

SELECT Orders.OrderID, Customers.CustomerName FROM Orders INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID;