SQL-complete-tutorial

1
SELECT * 
2
FROM sql_store.customers
3
ORDER BY first_name;
4

5
SELECT * 
6
FROM sql_store.customers
7
ORDER BY state DESC, first_name DESC;
8

9
SELECT first_name, last_name
10
FROM sql_store.customers
11
ORDER BY birth_date;
12

13
SELECT first_name, last_name, 10 AS points
14
FROM sql_store.customers
15
ORDER BY points, first_name;
16

17
-- Select only orders with order_id = 2 and sort the data by the total price
18
SELECT *, quantity * unit_price AS total_price 
19
FROM sql_store.order_items
20
WHERE order_id = 2
21
ORDER BY total_price DESC;
22

23