题解 | #返回所有价格在 3美元到 6美元之间的产品的名称和价格#
返回所有价格在 3美元到 6美元之间的产品的名称和价格
http://www.nowcoder.com/practice/e4268b4e044e4b94875c238098d98cf8
# SELECT # prod_name, # prod_price # FROM # Products # WHERE # prod_price BETWEEN 3 AND 6 # ORDER BY # prod_price; SELECT prod_name, prod_price FROM Products WHERE prod_price >= 3 AND prod_price <= 6 ORDER BY prod_price;
查看17道真题和解析