SQL-complete-tutorial

1
USE sql_store;
2
SELECT
3
	order_id, 
4
    order_date,
5
    IF(YEAR(order_date) = YEAR(NOW()), 
6
    'Active', 
7
    'Archived') AS category
8
FROM orders;
9

10
SELECT 
11
	product_id,
12
    name,
13
    COUNT(*) AS orders,
14
    IF(COUNT(*) > 1, 
15
    'Many times', 'Once') AS frequency
16
FROM products
17
JOIN order_items USING (product_id)
18
GROUP BY product_id, name;