/*------------------------
SELECT OrderID,
ItemID,
'$' + cast (price as char (10)) as [Price],
'$' + CAST(CAST(ROUND(price * 0.06, 2) AS DECIMAL(18,2)) AS VARCHAR(8)) AS [Sales Tax],
'$' + CAST(CAST(ROUND((price * .06) + price, 2) AS DECIMAL(18,2)) AS VARCHAR(8)) AS [Subtotal]
from ORDER_ITEM
where price >= 20
order by OrderID;
------------------------*/
OrderID ItemID Price Sales Tax Subtotal
----------- ----------- ----------- --------- ---------
1004 1004 $32.50 $1.95 $34.45
1016 1020 $47.95 $2.88 $50.83
1018 1018 $47.50 $2.85 $50.35
1019 1017 $80.00 $4.80 $84.80
1020 1019 $30.00 $1.80 $31.80
1021 1031 $25.99 $1.56 $27.55
1031 1029 $82.50 $4.95 $87.45
1032 1037 $85.00 $5.10 $90.10
1033 1032 $100.00 $6.00 $106.00
1035 1038 $145.00 $8.70 $153.70
1036 1049 $20.00 $1.20 $21.20
1038 1054 $57.50 $3.45 $60.95
2001 2000 $175.50 $10.53 $186.03
2002 2002 $125.00 $7.50 $132.50
3021 2030 $35.00 $2.10 $37.10
3022 2031 $145.00 $8.70 $153.70

(16 row(s) affected)