SQL-complete-tutorial

1
USE sql_store;
2
SELECT 
3
	order_id,
4
    CASE
5
		WHEN YEAR(order_date) = YEAR(NOW()) THEN 'Active'
6
        WHEN YEAR(order_date) = YEAR(NOW()) - 1 THEN 'Last Year'
7
        WHEN YEAR(order_date) < YEAR(NOW()) - 1 THEN 'Archived'
8
        ELSE 'Future'
9
	END AS category
10
FROM orders;
11

12
SELECT
13
	CONCAT(first_name, ' ', last_name) AS customer,
14
    points,
15
    CASE
16
		WHEN points > 3000 THEN 'Gold'
17
        WHEN points BETWEEN 2000 AND 3000 THEN 'Silver'
18
        WHEN points < 2000 THEN 'Bronze'
19
	END AS category
20
FROM customers
21
ORDER BY points DESC;