会编程的发呆爱好者加麻加辣

分类

/ 注册

全部文章（共208篇）

题解 | 各个视频的平均完播率

select tu.video_id, round(count(case when timestampdiff(second,tu.start_time,tu.end_time)>=tv.duration then 1 else null end)/count(*),3) as avg_com...

2025-04-13

0 24

题解 | 商品id数据清洗统计

select substr(order_id,6,4) as product_id, count(substr(order_id,6,4)) cnt from order_log group by substr(order_id,6,4) order by cnt desc limit 1 简单

2025-04-12

0 30

题解 | 查询订单

select order_id,customer_name,order_date from( select o.order_id,c.customer_name,o.order_date,row_number() over(partition by c.customer_id order by o....

2025-04-12

0 37

题解 | 每个部门薪资排名前两名员工

select department, employee_name, salary from ( select department, employee_name, salary,rank() over(partition by department order by salary desc) as ...

2025-04-12

0 38

题解 | 每个客户的账户总金额

select customer_id,sum(balance) as sum_balance from account group by customer_id order by sum_balance desc,customer_id 这真是大厂题目吗？？大厂会出这么简单的题？？

2025-04-12

0 19

题解 | 商品销售总额分布

select CASE WHEN u.pay_method = '' THEN 'error' ELSE u.pay_method END AS pay_method, count(*) as cnt from user_client_log u join product_info p on u....

2025-04-12

0 27

题解 | 商品销售排名

select p.product_name, count(u.product_id)*p.price as money from user_client_log u join product_info p on u.product_id = p.product_id where u.pay_meth...

2025-04-12

0 25

题解 | 商品价格排名

select product_id,product_name,type,price from( select product_id,product_name,type,price,dense_rank() over(partition by type order by price desc)...

2025-04-12

0 19

题解 | 用户购买次数前三

select uid, count(uid) as cnt from user_client_log where step = 'order' group by uid order by cnt desc,uid limit 3 简单

2025-04-11

0 21

题解 | 下单最多的商品

select u.product_id, count(u.product_id) as cnt from user_client_log u join product_info p on u.product_id=p.product_id where u.step = 'order' group ...

2025-04-11

0 20