蚊抑青年小王

分类

/ 注册

全部文章（共24篇）

题解 | 商品交易(网易校招笔试真题)

select g.id, g.name, g.weight, sum(count) total from goods g join trans t on g.id = t.goods_id where weight < 50 group ...

2025-03-26

0 79

题解 | 网易云音乐推荐(网易校招笔试真题)

SELECT music_name FROM ( SELECT DISTINCT m.id, m.music_name FROM follow f JO...

2025-03-24

0 79

题解 | 网易云音乐推荐(网易校招笔试真题)

select music_name from ( select distinct m.id, music_name from follow f join m...

2025-03-24

0 76

题解 | 淘宝店铺的实际销售额与客单价

select round(sum(sales_num * goods_price), 3) sales_total, round( sum(sales_num * goods_price) / count(distinct user_id), 3 ...

2025-03-21

0 86

题解 | 统计加班员工占比

select department, concat ( round( sum( case when work_time > 9.5 then 1 ...

2025-03-21

0 73

题解 | 每天登陆最早的用户的内容喜好

select log_day, user_id, hobby from ( select date (log_time) log_day, user_id, dense_rank(...

2025-03-20

0 69

题解 | 统计各个部门平均薪资

select department, round( sum(normal_salary - dock_salary) / count(staff_id), 3 ) avg_salary from staff_tb join sa...

2025-03-19

0 99

题解 | 查询单日多次下订单的用户信息？

select date (order_time) order_date, user_id, count(order_id) order_nums, vip from order_tb join uservip_tb using (user_id) gr...

2025-03-18

0 73

题解 | 单组_spj判断数组之和

import java.util.Scanner; import java.util.*; // 注意类名必须为 Main, 不要有任何 package xxx 信息 public class Main { public static void main(String[] args) { ...

2025-03-17

0 65

题解 | 单组_spj判断浮点误差

import java.util.Scanner; // 注意类名必须为 Main, 不要有任何 package xxx 信息 public class Main { public static void main(String[] args) { Scanner in =...

2025-03-17

0 66