eagle10

分类

/ 注册

全部文章（共29篇）

题解 | 实习广场投递简历分析(三)

WITH t1 AS ( SELECT job, DATE_FORMAT(date, '%Y-%m') AS first_year_mon, SUM(num) AS first_year_cnt, ...

2025-06-30

0 15

题解 | 哪些产品在特定时间段内表现最为出色

with t1 as ( select product_id, sum(sales_quantity) as total_sales_quantity, sum(sales_amount) as tota...

2025-06-28

0 10

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

with t1 as ( select uid, min(event_time) as event_time from tb_order_detail left j...

2025-05-26

0 23

题解 | 商品价格排名

select product_id, product_name, type, price from ( select product_id, product_name, type, price, dense_rank() over (...

2025-05-22

0 26

题解 | 短视频直播间晚上11-12点之间各直播间的在线人数

select room_id, room_name, count(distinct user_id) as user_count from user_view_tb left join room_info_tb using (room_id) WHERE ...

2025-05-21

0 20

题解 | 统计快递运输时长

select exp_type, round(avg(timestampdiff (SECOND, out_time, in_time)/3600),1) as time from express_tb left join exp_action_tb using (...

2025-05-20

0 33

题解 | 每个顾客最近一次下单的订单信息

select orders.order_id, customer_name, orders.order_date from ( select customer_id, max(order_date) as...

2025-05-19

0 32

题解 | 每个顾客购买的最新产品名称

select t2.customer_id, customer_name, product_name as latest_order from ( select orders.* from ...

2025-05-19

0 25

题解 | 完成员工考核试卷突出的非领导员工

select emp_id,emp_level,tag from exam_record left join ( select exam_id, tag, avg(score) as avg_sc...

2025-05-16

0 29

题解 | 商品销售总额分布

select if(pay_method='' , 'error',pay_method), count(*) as ranks from user_client_log left join product_info using (product_id) where ...

2025-05-15

0 28