Your First 5 Minute of SQL CODE

Resources:

• SQL Try-It Editor
• Lecture Slides

Step 1.

SELECT * FROM customers; 

Step 2.

SELECT * FROM orders; 

Step 3.

SELECT * 
FROM products
ORDER BY Price DESC;

Step 4.

SELECT 
 customerName,
 COUNT(*) AS 'number of orders'
FROM customers
INNER JOIN orders
 ON orders.customerID = customers.customerID
GROUP BY customers.customerID;