CODE EXAMPLE FOR SQL

SQL CASE Statement

SELECT order_id, customer_id,
CASE
    WHEN amount >= 400 THEN (amount - amount * 10/100)
END AS offer_price
FROM Orders;