zyt33
zyt33
全部文章
分类
题解(20)
归档
标签
去牛客网
登录
/
注册
zyt33的博客
全部文章
(共17篇)
题解 | #得分不小于平均分的最低分#
select date_format(start_time,'%Y%m') month , round(COUNT(DISTINCT uid,DATE_FORMAT(start_time,'%Y%m%d')) /count(DISTINCT uid) ,2) avg_active_days, COU...
Mysql
2022-02-23
0
243
题解 | #得分不小于平均分的最低分#
SELECT MIN(score) min_score_over_avg FROM (SELECT er.exam_id ,tag,score , AVG(score) OVER (PARTITION BY tag) a FROM exam_record er RIGHT JOIN examinat...
Mysql
2022-02-21
0
194
题解 | #SQL类别高难度试卷得分的截断平均值#
一: SELECT tag,difficulty, ROUND( (SUM(score)-MAX(score)-MIN(score))/(COUNT(score)-2) ,1) clip_avg_score FROM examination_info ei RIGHT JOIN exam_recor...
Mysql
2022-02-21
0
256
题解 | #商品交易(网易校招笔试真题)#
SELECT goods_id AS id, NAME, weight , SUM(COUNT) total FROM ( SELECT goods_id, NAME,weight,COUNT FROM trans t LEFT JOIN goods g ON g.id=t.goods_id)a G...
Mysql
2022-02-04
0
169
题解 | #获得积分最多的人(三)#
SELECT DISTINCT(id),NAME,grade_sum FROM user u LEFT JOIN (SELECT ,RANK() OVER (ORDER BY grade_sum DESC) r FROM (SELECT user_id,SUM(g) OVER (PARTITION ...
Mysql
2022-02-04
0
156
题解 | #获得积分最多的人(二)#
SELECT id,name ,t FROM user u RIGHT JOIN (SELECT user_id,SUM(grade_num) OVER (PARTITION BY user_id) t FROM grade_info ORDER BY t DESC ) a ON u.id = a....
Mysql
2022-02-03
0
170
题解 | #获得积分最多的人(一)#
SELECT name ,t FROM user u RIGHT JOIN (SELECT user_id,SUM(grade_num) OVER (PARTITION BY user_id) t FROM grade_info ORDER BY t DESC LIMIT 1) a ON u.id ...
Mysql
2022-02-03
0
186
题解 | #实习广场投递简历分析(三)#
SELECT a.job, a.mon first_year_mon, a.cnt first_year_cnt,b.mon second_year_mon,b.cnt second_year_cnt FROM (SELECT job, DATE_FORMAT(date,'%Y-%m') mon ,...
Mysql
2022-01-29
1
255
题解 | #牛客的课程订单分析(七)#
SELECT CASE WHEN source IS NOT NULL THEN source ELSE 'GroupBuy' END source, COUNT() FROM (SELECT a. ,c.name source FROM (SELECT ,COUNT() OVER (PARTITI...
Mysql
2022-01-28
0
154
题解 | #牛客的课程订单分析(六)#
SELECT id,is_group_buy , name client_name FROM (SELECT ,COUNT() OVER (PARTITION BY user_id) rn FROM ( SELECT o.* ,c.name FROM order_info o LEFT JOIN ...
Mysql
2022-01-27
0
227
首页
上一页
1
2
下一页
末页