15 lines
223 B
Bash
15 lines
223 B
Bash
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
|
|
|