牛客102435226号

分类

/ 注册

全部文章（共15篇）

题解 | 查询成绩

select count(*) from (select h2.sname,sum(score)/3 as avg_score from (select sId,cId,score from SC ) as h1 left outer join ( select sId,sname from Stu...

2025-02-13

0 59

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

select h1.goods_id as id,h2.name,h2.weight,h1.total from (select goods_id,sum(count) as total from trans group by goods_id ) as h1 left outer join ( ...

2025-02-13

0 59

题解 | 请写出计算粉丝ctr的sql语句

select sum(h1.read_num) / sum(h1.show_num) as fans_ctr from ( select c.content_id, fans_id, show_n...

2025-02-12

0 61

题解 | #21年8月份练题总数#

select count(distinct device_id) as did_cnt,count(question_id) as question_cnt from question_practice_detail where substr(date,6,2)='08'

2024-12-02

0 66

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

select c.user_id,c.room_id,c.room_type,c.daysfrom (select b.user_id,a.room_id,a.room_type,datediff(b.checkout_time,b.checkin_time) as daysfrom checkin...

2024-08-16

0 154