USE Atlantic;
GO
SELECT P.product_name
, FORMAT(P.product_cost_price, 'C', 'un-us') AS Price
, IIF(P.product_cost_price > 10,'Dear', 'Cheap') AS one_tier_test
FROM Product AS P
GO
SELECT P.product_name
, FORMAT(P.product_cost_price, 'C', 'un-us') AS Price
, IIF(P.product_cost_price > 5
	, IIF(P.product_cost_price > 110
		, IIF(P.product_cost_price > 200 
		, 'Dear', 'Affordable') 
	, 'Cheap') 
, 'Too Cheap')
 AS three_tier_test
FROM Product AS P