SQL_Data_Engineering/conditionals.sql at main · theyashva/SQL_Data_Engineering · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
USE ecom_db;

--  CASE WHEN STATEMENTS : apply multiple conditions

SELECT * FROM dim_product;

SELECT
    *,
    CASE
        WHEN unit_price<=100 THEN 'low price'
        WHEN unit_price<=300 THEN 'normal price'
        WHEN unit_price<=500 THEN 'high price'
        ELSE 'expensive'
    END AS 'price_tone'
FROM
    dim_product;