SELECT ORDERS.orderid,
INVENTORY.partid,
Inventory.description,
ORDERITEMS.qty,
Inventory.price,
(OrderItems.qty * Inventory.price) AS 'Total Original Price',
(OrderItems.qty * Inventory.price *
CASE
WHEN OrderItems.qty >= 10 THEN 0.05
when orderItems.qty < 10 Then 0.02
END) AS 'Total Discount Value',
OrderItems.qty * Inventory.price - (OrderItems.qty * Inventory.price *
CASE
WHEN OrderItems.qty >= 10 THEN 0.05
when OrderItems.qty < 10 THEN 0.02
else 0
END) AS 'Total_Final_Price_After_Discount'
FROM orders, inventory, orderitems
WHERE ORDERS.ORDERID = ORDERITEMS.ORDERID
AND ORDERITEMS.PARTID = INVENTORY.PARTID<small></small>