Business Analyst: What is a CASE statement in SQL?

1SELECT
2  name,
3  amount,
4  CASE
5    WHEN amount > 1000 THEN 'Large'
6    WHEN amount > 100 THEN 'Medium'
7    ELSE 'Small'
8  END as order_size
9FROM orders;

1-- Calculate discount
2SELECT
3  order_id,
4  amount,
5  CASE
6    WHEN is_vip = 1 THEN amount * 0.2
7    WHEN amount > 100 THEN amount * 0.1
8    ELSE 0
9  END as discount
10FROM orders;