白色森林

分类

/ 注册

全部文章（共49篇）

题解 | 查询出每个运输方式在不同城市的平均运输时长以及总运输费用

SELECT o.destination_city, t.transport_name, ROUND(AVG(TIMESTAMPDIFF(DAY,o.order_date,o.delivery_date)),2) AS average_transport_duration, ...

2025-10-05

0 19

题解 | 统计创作者

SELECT a.author_id, a.author_name, COUNT(p.post_id) AS posts_30d, SUM(p.like_cnt) AS likes_30d, ROUND(SUM(p.like_cnt) / COUNT(p.po...

2025-10-03

0 20

题解 | 查询出每个品牌在不同月份的总销售额以及购买该品牌商品的用户的平均年龄

SELECT o.category_id, SUM(o.order_amount) AS total_sales, SUM(CASE WHEN c.customer_gender='男' THEN 1 ELSE 0 END) AS male_customers, SU...

2025-10-03

0 22

题解 | 电商平台想要查询出每个商品在 2024 年上半年（1 月至 6 月）的总销售额

SELECT p.product_id, p.product_name, SUM(p.price*s.quantity) AS total_sales FROM products_underline AS p INNER JOIN sales_unde...

2025-10-03

0 22

题解 | 了解 2023 年全年所有商品的盈利情况

SELECT s.product_id, SUM((s.unit_price-p.purchase_price)*s.quantity) AS total_profit, ROUND((AVG(s.unit_price)-AVG(p.purchase_price))/p.pu...

2025-09-19

0 18

题解 | 物流公司想要分析快递小哥的收入情况

SELECT c.courier_id, c.courier_name, SUM(d.delivery_fee)+c.base_salary AS total_income FROM couriers_info AS c INNER JOIN deli...

2025-09-08

0 31

题解 | 统计快递从创建订单到发出间隔时长

SELECT ROUND(AVG(TIMESTAMPDIFF(minute,e.create_time,ea.out_time))/60,3) AS time FROM express_tb AS e INNER JOIN exp_action_tb AS ea ON...

2025-09-04

1 26

题解 | 分析不同门店各类商品的库存情况和销售情况

SELECT s.store_id, s.store_name, p.product_category, SUM(si.inventory_quantity) AS inventory_quantity, SUM(si.sales_amount) AS sal...

2025-09-04

0 26

题解 | 查询产生理赔费用的快递信息

SELECT e.exp_number, e.exp_type, ec.claims_cost FROM express_tb AS e INNER JOIN exp_cost_tb AS ec ON e.exp_number=ec.exp_numbe...

2025-09-02

1 24

题解 | 淘宝店铺的实际销售额与客单价

SELECT ROUND(SUM(s.sales_num*g.goods_price),3) AS sales_total, ROUND(SUM(s.sales_num*g.goods_price)/COUNT(DISTINCT s.user_id),3) AS per_trans ...

2025-09-02

1 23