分析

关键词：where

用法：select [列名] from [表名] where 判断条件 order by ..

判断条件：between [下届] and [上届]

代码

select prod_name,prod_price
from Products
where prod_price between 3 and 6
order by prod_price