谦虚的比尔在炒股

分类

/ 注册

TA的专栏 0篇文章 0人订阅

sql练习-面试前刷题

0篇文章 0人学习

全部文章（共81篇）

题解 | 查询下订单用户访问次数？

select vtb.user_id, count(visit_time) as visit_nums from ( select distinct user_id from order_tb wher...

2025-06-03

0 21

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

select utb.vip, sum(if(order_price is null,0,order_price)) as order_total from uservip_tb as utb left join order_tb a...

2025-06-03

0 23

题解 | 统计商家不同会员每日访问人次及访问人数

select utb.vip, count(vtb.user_id) as visit_nums, count(distinct vtb.user_id) as visit_users from visit_tb as vtb lef...

2025-06-03

0 23

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

select user_id from ( select user_id, count(date_sub_rn) as continue_days from ( select user_id, ...

2025-05-30

0 29

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

select post, round(avg(work_time),3) as work_hours from ( select s_tb.staff_id, s_tb.post, timestampdiff(m...

2025-05-30

0 27

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

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

2025-05-28

0 21

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

select round(sum(score) / count(rec_user),3) avg_score from ( select distinct rc_tb.rec_user, u_a_tb.score from ...

2025-05-28

0 25

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

select a.staff_id, st.staff_name from ( select staff_id from cultivate_tb where course lik...

2025-05-28

0 22

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

select sum(cnt) staff_nums from ( select *, case when length(course) = 7 then 1 when length(course...

2025-05-28

0 23

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

select * from ( select a.user_id, a.room_id, gr_tb.room_type, datediff(checkout_time,checkin_time) days ...

2025-05-28

0 29