select count(1) from TABLENAME where price<10这个比较简单的问题, 题主可以再看看课本的基础.
select count(*) from [表名] where [单价]<10
