USE Mall
GO

SET NOCOUNT ON

------ return two columns that the price bigger than average price ------
-- ********** Begin ********** --
SELECT  prod_name,prod_price
FROM Products
WHERE prod_price>(SELECT AVG (prod_price) FROM Products)

-- ********** End ********** --

GO