最爱青草蛋糕

分类

/ 注册

全部文章（共74篇）

题解 | 月均完成试卷数不小于3的用户爱作答的类别

#筛选用户 with t1 as (select uid,count(uid) from exam_record er where date_format(start_time,'%Y-%m') = date_format(submit_time,'%Y-%m') and date_format(s...

2025-09-18

0 15

题解 | 月均完成试卷数不小于3的用户爱作答的类别

#筛选用户 with t1 as (select uid,count(uid) from exam_record er where date_format(start_time,'%Y-%m') = date_format(submit_time,'%Y-%m') and date_format(s...

2025-09-18

0 16

题解 | 月总刷题数和日均刷题数

select date_format(submit_time,'%Y%m') as submit_month,count(1) as month_q_cnt,round(count(1)/dayofmonth(last_day(max(submit_time))),3) as avg_day_q_c...

2025-09-18

0 14

题解 | 月总刷题数和日均刷题数

with t1 as (select date_format(submit_time,'%Y%m') as submit_month,count(1) as month_q_cnt,dayofmonth(last_day(submit_time)) as days_count from practi...

2025-09-18

0 13

题解 | 统计作答次数

with t1 as (select count(1) as total_pv, 'answer' as result from exam_record), t2 as (select count(1) as complete_pv,'answer' as result from exam_rec...

2025-09-17

0 18

题解 | 饿了么需要分析不同配送员在不同天气条件下的配送效率和用户投诉情况

with t1 as (select staff_id,average_speed from delivery_staff where average_speed > 20), t2 as ( select t1.staff_id as staff_id,weather_id,delivery...

2025-09-05

0 18

题解 | 分析员工在不同项目中的绩效表现以及所属部门的平均绩效情况

with t1 as (select e.employee_id as employee_id,performance_score,department_name from employee_projects e join department_info d on e.employee_id =...

2025-09-03

0 23

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

with t1 as (select o.order_id,category_id,order_amount,order_date,customer_id,customer_gender, case when customer_gender = '男' then 1 else 0 end as c...

2025-09-01

0 21

题解 | 分析每个员工在不同项目中的绩效情况

with t1 as (select e.employee_id as employee_id, employee_name,department,project_id, performance_score from employees e join performance per on e.emp...

2025-08-29

0 23

题解 | 查询出不同类别商品中，销售金额排名前三且利润率超过 20%的商品信息

with t1 as (select p.product_id as product_id,product_name,category_id,sales_amount,round((sales_amount-cost_amount)/sales_amount,2) as profit_rate,ra...

2025-08-29

0 21