勤奋努力的番石榴等oc

分类

/ 注册

全部文章（共5篇）

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

select a.staff_id,staff_name from staff_tb a join cultivate_tb b on a.staff_id=b.staff_id where course like('%course3%') 1 连接表2 只需要course 包含course3即可

2025-09-06

0 7

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

with shichang as( select staff_id,first_clockin,last_clockin, TIMESTAMPDIFF(MINUTE, first_clockin, last_clockin)/60 as gongzuo from attendent_tb)...

2025-09-06

0 8

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

with zhenghe as(select a.product_id,a.name,a.category,b.quantity from products a join orders b on a.product_id=b.product_id), jisuan as(select name,su...

2025-09-06

0 6

题解 | 有取消订单记录的司机平均评分

with siji as( select driver_id from tb_get_car_order where fare is null and date(order_time) between '2021-10-01'and '2021-10-31' )...

2025-08-13

0 19

题解 | 计算用户8月每天的练题数量

select day(date) as day, count(*) as question_cnt from question_practice_detail where month(date)=08 and year(date)=2021 group by day 1 day是从日期里面只取几号，...

2025-08-08

0 24