1 查询商品的总条数
SELECT COUNT(*)
FROM product;
2 查询价格大于200商品的总条数
SELECT COUNT(*)
FROM product
WHERE price > 200;
3 查询分类为’c001’的所有商品价格的总和
SELECT SUM(price)
FROM product
WHERE category_id = ‘c001’;
4 查询分类为’c002’所有商品的平均价格
SELECT AVG(price)
FROM product
WHERE category_id = ‘c002’;
5 查询商品的最大价格和最小价格
SELECT MAX(price),MIN(price)
FROM product;
(以后再找到再补充)
————————————————
SQL基本语句原文链接:https://blog.csdn.net/u011676417/article/details/86568017
————————————————
扩展:SQL执行顺序:
https://blog.csdn.net/weixin_43361722/article/details/104983910