USE Mall
GO

SET NOCOUNT ON

------ return the number of product which price bigger than 10 -----
-- ********** Begin ********** --
SELECT COUNT(*) 
FROM Products 
WHERE prod_price > 10
-- ********** End ********** --

GO