首页
题库
公司真题
专项练习
面试题库
在线编程
面试
面试经验
AI 模拟面试
简历
求职
学习
课程
专栏·文章
竞赛
搜索
我要招人
发布职位
发布职位、邀约牛人
更多企业解决方案
在线笔面试、雇主品牌宣传
登录
/
注册
胆小的柯基在努力
获赞
1
粉丝
0
关注
8
看过 TA
3
门头沟学院
2024
数据分析师
IP属地:湖北
暂未填写个人简介
私信
关注
拉黑
举报
举报
确定要拉黑胆小的柯基在努力吗?
发布(27)
刷题
胆小的柯基在努力
门头沟学院 电子信息类
@码农鬼仔:
【快手专场】技术岗最详面经汇总
已认证
0
点赞
评论
收藏
转发
胆小的柯基在努力
门头沟学院 电子信息类
@不二PM:
浅谈风控
0
点赞
评论
收藏
转发
胆小的柯基在努力
2023-07-23 13:44
门头沟学院 电子信息类
题解 | #分别满足两个活动的人#
select * from (select uid ,'activity1' as activity from exam_record where uid not in ( select uid from exam_record where score < 85 ) and year(submit_time) = 2021 ) as x union (select distinct uid ,'activity2' as activity from exam_record er join examination_info ei on er.exam_id = ei.e...
0
点赞
评论
收藏
转发
胆小的柯基在努力
2023-07-23 12:51
门头沟学院 电子信息类
题解 | #作答试卷得分大于过80的人的用户等级分布#
select level,count(level) as level_cnt from user_info where uid in (select distinct uid from exam_record where exam_id in ( select exam_id from examination_info where tag = 'SQL' ) and score > 80) group by level order by level_cnt desc;
0
点赞
评论
收藏
转发
胆小的柯基在努力
2023-07-23 12:45
门头沟学院 电子信息类
题解 | #试卷发布当天作答人数和平均分#
select exam_record.exam_id, count(distinct exam_record.uid) as uv, format (avg(score), 1) as avg_score from ( select exam_id, date (release_time) as date from examination_info where tag = 'SQL' ) as x_sql ...
0
点赞
评论
收藏
转发
胆小的柯基在努力
2023-06-29 00:39
门头沟学院 电子信息类
题解 | #月均完成试卷数不小于3的用户爱作答的类别#
select tag,count(tag) as tag_cnt from ( select tag from (select exam_id from ( select * from exam_record er where er.uid in ( # 查找月均完成试卷数不小于3的用户list select uid from ( select uid, round(count...
0
点赞
评论
收藏
转发
胆小的柯基在努力
2023-06-13 21:54
门头沟学院 电子信息类
题解 | #未完成试卷数大于1的有效用户#
SELECT uid, SUM(incomplete) AS incomplete_cnt, SUM(complete) AS complete_cnt, GROUP_CONCAT(DISTINCT detail SEPARATOR ';') AS detail FROM ( SELECT uid, CONCAT (DATE (start_time), ':', tag) AS detail, if (submit_time is not null, 1, 0) a...
0
点赞
评论
收藏
转发
胆小的柯基在努力
2023-06-13 20:37
门头沟学院 电子信息类
题解 | #修改表#
ALTER TABLE user_info ADD school varchar(15) AFTER level; ALTER TABLE user_info CHANGE COLUMN job profession varchar(10); ALTER TABLE user_info MODIFY COLUMN achievement int(11) DEFAULT 0;
0
点赞
评论
收藏
转发
胆小的柯基在努力
2023-06-06 13:02
门头沟学院 电子信息类
题解 | #月总刷题数和日均刷题数#
(select date_format(submit_time,'%Y%m') as submit_month, count(submit_time) as month_q_cnt, round(count(submit_time)/day(max(last_day(submit_time))),3) as avg_day_q_cnt from practice_record where year(submit_time) = '2021' group by submit_month ) union (select '2021汇总' as submit_month, c...
0
点赞
评论
收藏
转发
胆小的柯基在努力
2023-06-06 12:25
门头沟学院 电子信息类
题解 | #平均活跃天数和月活人数#
select date_format(submit_time,'%Y%m') as month_date, round(count(distinct uid,date_format(submit_time,'%Y%m%d'))/count(distinct uid),2) as avg_active_days, count(distinct uid) as mau from exam_record where date_format(submit_time,'%Y') = 2021 group by month_date 执行顺序:where子句对检索结果中每一条记录...
0
点赞
评论
收藏
转发
胆小的柯基在努力
2023-06-06 11:51
门头沟学院 电子信息类
题解 | #得分不小于平均分的最低分#
# 找到SQL试卷得分不小于该类试卷平均得分的用户最低得分。 SELECT score FROM exam_record JOIN examination_info USING(exam_id) WHERE tag='SQL' AND score >= (SELECT AVG(score) as score_avg FROM exam_record JOIN examination_info USING(exam_id) WHERE tag='SQL') ORDER BY score ASC LIMIT 1
0
点赞
评论
收藏
转发
胆小的柯基在努力
2023-06-06 11:43
门头沟学院 电子信息类
题解 | #统计作答次数#
# 统计出总作答次数total_pv、 # 试卷已完成作答数complete_pv、 # 已完成的试卷数complete_exam_cnt。 SELECT COUNT(id) AS total_pv, COUNT(score) AS complete_pv, (SELECT COUNT(DISTINCT exam_id) FROM exam_record WHERE score IS NOT NULL )AS complete_exam_cnt FROM exam_record
0
点赞
评论
收藏
转发
胆小的柯基在努力
2023-02-09 18:46
门头沟学院 电子信息类
题解 | #统计牛客网部分用户使用语言#
import pandas as pd df = pd.read_csv('Nowcoder.csv') print(df.loc[10:20,'Language'])
0
点赞
评论
收藏
转发
胆小的柯基在努力
2023-02-06 15:52
门头沟学院 电子信息类
题解 | #插入记录(一)#
INSERT INTO exam_record(uid,exam_id,start_time,submit_time,score) VALUES (1001,9001,'2021-09-01 22:11:12','2021-09-01 23:01:12',90), (1002,9002,'2021-09-04 07:01:02',null,null) ;
0
点赞
评论
收藏
转发
胆小的柯基在努力
2022-10-11 17:39
已编辑
门头沟学院 电子信息类
题解 | #组合#
UNION和ORDER BY链接union在没有括号的情况下只能使用一个order by——意思就是先union,然后对整个结果集进行order byselect prod_name from Products union select cust_name from Customers order by prod_name;
0
点赞
评论
收藏
转发
1
2
工具箱
TA的圈子
暂未加入圈子
TA的圈子
TA的笔记
暂无笔记
TA的笔记
登录
0
天
已登录
0
天
连续登录
0
人
今日访客
牛客网
牛客企业服务