拒绝996的小蜗牛很自信

分类

/ 注册

全部文章（共20篇）

题解 | #分析客户逾期情况#

select pay_ability, concat(round(count(overdue_days)/count(customer_id)*100,1),'%') as overdue_ratio from customer_tb join loan_tb using(customer_id) ...

2024-08-10

0 110

题解 | #获取指定客户每月的消费额#

select date_format(t_time,'%Y-%m') as time, sum(t_type*t_amount) as total from trade where t_cus in (select c_id from customer where c_name = 'Tom'...

2024-08-10

4 194

题解 | #查询连续入住多晚的客户信息？#

select user_id, room_id, room_type, datediff (checkout_time,checkin_time) as days from checkin_tb join guestroom_tb using(room_id) where datediff(che...

2024-08-10

0 157

题解 | #统计所有课程参加培训人次#

select sum(length(course)-length(replace(course,',',''))+1) as staff_nums from cultivate_tb

2024-08-10

99 343

题解 | #查询培训指定课程的员工信息#

select staff_id,staff_name from staff_tb where staff_id in (select staff_id from cultivate_tb where course like '%course3%') order by staff_id 包含co...

2024-08-10

0 113

题解 | #推荐内容准确的用户平均评分#

select round(sum(score)/count(distinct user_id),3) as avg_score from user_action_tb where user_id in (select user_id from user_action_tb as tb1 join...

2024-08-09

18 205

题解 | #每个商品的销售总额#

select name as product_name, sum(quantity) as total_sales, row_number()over(partition by category order by category,sum(quantity) desc) as category_r...

2024-08-09

7 179

题解 | #查询连续登陆的用户#

select user_id from register_tb where user_id in (select tb1.user_id from login_tb as tb1 join (select user_id,log_time from login_tb) as tb2 on tb...

2024-08-09

9 156

题解 | #统计各岗位员工平均工作时长#

select post, round(avg(timestampdiff(minute,first_clockin,last_clockin))/60,3) as work_hours from staff_tb join attendent_tb using(staff_id) where fi...

2024-08-09

18 271

题解 | #未完成试卷数大于1的有效用户#

select uid,sum(if(submit_time is null, 1, 0)) as incomplete_cnt, count(submit_time) as complete_cnt, group_concat(distinct concat(date_format(start_ti...

2024-08-07

0 136