存几分期许

分类

/ 注册

全部文章（共167篇）

题解 | 最受欢迎的top3课程

with t as ( select uid, a.cid, score, release_date, start_time, round(timestampdiff(minute, start_time, end_time), 3) as diff from play_re...

2025-08-12

0 46

题解 | 更新员工信息表

select EMPLOYEE_ID, case when LAST_UPDATE_DT_new>LAST_UPDATE_DT then NEW_POSITION else POSITION end as POSITION, case when LAST_UPDATE_DT_new>LA...

2025-08-12

0 44

题解 | 未下单用户登陆渠道统计

select channel, count(1) as cnt from user_info a left join order_log b on a.uid=b.uid where b.uid is null group by channel order by cnt desc, channel ...

2025-08-12

0 35

题解 | 用户订单信息查询

select city, sum(total_amount) as total_order_amount from orders a join customers b on a.customer_id=b.customer_id group by city order by total_order_...

2025-08-12

0 49

题解 | 未下单用户统计

select count(1) as cnt from user_info a left join order_log b on a.uid=b.uid where b.uid is null

2025-08-12

0 40

题解 | 返回顾客名称和相关订单号以及每个订单的总价

select cust_name, b.order_num, sum(quantity*item_price) as OrderTotal from Customers a join Orders b on a.cust_id=b.cust_id join OrderItems c on b.ord...

2025-08-12

0 43

题解 | 输出播放量最高的视频

with t as ( select a.cid, a.id, count(1) as cnt from play_record_tb a join play_record_tb b on a.cid=b.cid and a.start_time>=b.start_ti...

2025-08-12

0 42

题解 | 每个顾客购买的最新产品名称

with t as ( select customer_id, product_id from orders where (customer_id, order_date) in ( select customer_id, max(order_date) ...

2025-08-12

0 27

题解 | 各个部门实际平均薪资和男女员工实际平均薪资

with t as ( select department, staff_gender, normal_salary-dock_salary as actual_salary from staff_tb a join salary_tb b on a.staff_id=b.staff...

2025-08-12

0 40

题解 | 统计每个产品的销售情况

with t as ( select a.product_id, unit_price*quantity as sales, unit_price, quantity, order_date, case when customer_age>=1 and custo...

2025-08-10

1 24