数据表格,创造数据都在上篇文章MySQL常用语句里,可以在我的栏目里看到。
这篇写MySQL汇总数据
求产品价格的平均数
select avg(prod_price) as avg_price from products;
求顾客总数
select count(*) as num_cust from Customers;
求有电子邮件的顾客总数
select count(cust_email) as num_cust from Customers;
返回价格最大值
select max(prod_price) as max_price from products;
返回价格最小值
select min(prod_price) as min_price from products;
求20005的订单数量总数
select sum(quantity) as items_ordered from orderItems where order_num=20005;