sql练习

1: 查询某一个商家的业绩。

SELECT SUM(r.amount) amount
FROM customer_order o,item_shop s,transaction_record r
WHERE o.`item_shop_id`=s.`id` AND o.`order_no`=r.`order_code` AND s.`name` LIKE ‘%晨光%‘ AND o.`order_status`=5
GROUP BY o.`item_shop_id`;

2: 查询前10位买家。

SELECT o.`customer_id`
FROM customer_order o
WHERE o.`order_status`=5
GROUP BY o.`customer_id`
ORDER BY COUNT(1) DESC
LIMIT 10;

3: 平台的第一季度营业额

SELECT SUM(r.`amount`) AS amount
FROM customer_order o,transaction_record r
WHERE o.`order_no`=r.`order_code` AND o.`order_status`= 5
AND o.`create_time` BETWEEN STR_TO_DATE(
‘2019-01-01‘,
‘%Y-%m-%d %H‘
)
AND STR_TO_DATE(
‘2019-03-31‘,
‘%Y-%m-%d %H‘
);

sql练习

原文：https://www.cnblogs.com/tiantianmamababa/p/10751933.html