SQL-complete-tutorial

1
SELECT 
2
	order_id,
3
    order_date,
4
    'Active' AS status
5
FROM orders
6
WHERE order_date >= '2019-01-01'
7
UNION
8
SELECT 
9
	order_id,
10
    order_date,
11
    'Archived' AS status
12
FROM orders
13
WHERE order_date < '2019-01-01';
14

15
SELECT name AS full_name
16
FROM shippers
17
UNION
18
SELECT first_name
19
FROM customers;
20

21
-- Define type of customers in three levels, based on points
22
SELECT 
23
	c.customer_id,
24
    c.first_name,
25
    c.points,
26
    'Bronze' AS type
27
FROM customers c
28
WHERE points < 2000
29
UNION
30
SELECT 
31
	c.customer_id,
32
    c.first_name,
33
    c.points,
34
    'Silver' AS type
35
FROM customers c
36
WHERE points BETWEEN 2000 AND 3000
37
UNION
38
SELECT 
39
	c.customer_id,
40
    c.first_name,
41
    c.points,
42
    'Gold' AS type
43
FROM customers c
44
WHERE points > 3000
45
ORDER BY first_name;