USE Mall
Go

SET NOCOUNT ON

---------- retrieving with limited ----------
-- ********** Begin ********** --
SELECT prod_name 
FROM Products 
WHERE prod_name LIKE '%toy%'
-- ********** End ********** --
GO

---------- retrieving with expression ----------
-- ********** Begin ********** --
SELECT prod_price, prod_price * 0.8 AS discount_price
FROM Products
WHERE prod_price > 3
-- ********** End ********** --
GO