纯粹爱刷题294408346

分类

/ 注册

全部文章（共25篇）

题解 | 每天登陆最早的用户的内容喜好

WITH first_login AS( SELECT user_id, DATE(log_time) AS log_day, rank() over(partition by DATE(log_time) order by log_time...

2025-03-16

0 36

题解 | 统计加班员工占比

WITH attendent AS( SELECT staff_id, if( TIMESTAMPDIFF(second,first_clockin,last_clockin)/3600>9.5, #需要使用secound-&g...

2025-03-16

0 35

题解 | 统计各个部门平均薪资

WITH salary AS( SELECT staff_id, normal_salary-dock_salary AS salary FROM salary_tb WHERE normal_salary-dock_salary betwe...

2025-03-15

0 42

题解 | 查询单日多次下订单的用户信息？

WITH orderA AS( #注意order是保留字段，需要重新署名 SELECT DATE(order_time) AS order_date, user_id, COUNT(distinct order_time) AS order_...

2025-03-15

0 49

题解 | 统计各等级会员用户下订单总额

WITH total AS( SELECT order_tb.*, uservip_tb.vip FROM order_tb LEFT JOIN uservip_tb ON order_tb.user_id=uservip_tb.us...

2025-03-05

0 26