我的名字在哪里

分类

/ 注册

全部文章（共44篇）

题解 | 智能家居设备高能耗异常监控分析

WITH a AS( SELECT em.device_id, device_name, category, UPPER(REPLACE(location,' ','_' )) location_code, usage_kwh FROM smart_devices sd JOIN energy_l...

2026-04-15

0 17

题解 | 分析每个商品在不同时间段的销售情况

WITH a AS( SELECT product_info.product_id, product_name, category, total_amount FROM product_info LEFT JOIN order_info ON product_info.pr...

2026-04-14

0 14

题解 | 电商平台需要对商家的销售业绩、退款情况和客户满意度进行综合评估

WITH sales_agg AS ( SELECT merchant_id, SUM(sale_amount) AS total_sales FROM sales_underline GROUP BY merchant_id ), refunds_agg AS ( ...

2026-04-14

0 17

题解 | 各城市最大同时等车人数

WITH a AS ( SELECT city, event_time AS checktime, DATE(event_time) AS dt, -- 提取日期 1 AS uv FROM tb_get_car...

2026-04-13

0 20

题解 | 国庆期间近7日日均取消订单量

SELECT dt, finish_num_7d, cancel_num_7d FROM ( SELECT dt, ROUND( SUM(finish_cnt) OVER ( ...

2026-04-11

0 24

题解 | 店铺901国庆期间的7日动销率和滞销率

/* SELECT dt, ROUND(cnt / total_cnt, 3) AS sale_rate, ROUND(1 - cnt / total_cnt, 3) AS unsale_rate FROM ( SELECT DISTINCT DATE(event_time) AS dt, ( SE...

2026-04-10

0 25

题解 | 10月的新户客单价和获客成本

WITH a AS( SELECT too.uid, tod.order_id, DATE(too.event_time) date, DENSE_RANK() OVER(PARTITION BY too.uid ORDER BY too.event_time) rk, ...

2026-04-10

0 19

题解 | 某店铺的各商品毛利率及店铺整体毛利率

WITH a AS( SELECT tb_order_detail.order_id, tb_order_detail.product_id, tb_order_detail.price, tb_order_detail.cnt, tb_order_...

2026-04-10

0 21

题解 | 有取消订单记录的司机平均评分

SELECT IFNULL(driver_id, "总体") as driver_id, ROUND(AVG(grade), 1) as avg_grade FROM tb_get_car_order WHERE driver_id in ( SELECT dri...

2026-04-10

0 19

题解 | 某乎问答最大连续回答问题天数大于等于3天的用户及其对应等级

WITH a AS( SELECT author_tb.author_id, author_tb.author_level, answer_tb.answer_date FROM author_tb JOIN answer_tb U...

2026-04-10

0 24