首页
题库
公司真题
专项练习
面试题库
在线编程
面试
面试经验
AI 模拟面试
简历
求职
学习
课程
专栏·文章
竞赛
搜索
我要招人
发布职位
发布职位、邀约牛人
更多企业解决方案
在线笔面试、雇主品牌宣传
登录
/
注册
害怕一个人的王老五是单身
获赞
0
粉丝
0
关注
0
看过 TA
9
男
贵州大学
2022
Java
IP属地:贵州
想向大佬们学好计算机
私信
关注
拉黑
举报
举报
确定要拉黑害怕一个人的王老五是单身吗?
发布(20)
刷题
害怕一个人的王老五是单身
2023-07-29 15:15
Java
题解 | #各个视频的平均完播率#
SELECT a.video_id, FORMAT(SUM(IF((UNIX_TIMESTAMP(end_time)-UNIX_TIMESTAMP(start_time))>=duration,1,0))/COUNT(a.video_id),3) AS avg_comp_play_rate FROM tb_user_video_log AS a,tb_video_info AS b WHERE a.video_id=b.video_id AND YEAR(start_time)=2021 GROUP BY a.video_id ORDER BY avg_comp_play_rate D...
0
点赞
评论
收藏
转发
害怕一个人的王老五是单身
2023-07-29 14:40
Java
题解 | #浙大不同难度题目的正确率#
SELECT c.difficult_level,SUM(IF(result='right',1,0))/COUNT(result) AS correct_rate FROM user_profile AS a,question_practice_detail AS b,question_detail AS c WHERE a.university='浙江大学' AND a.device_id=b.device_id AND b.question_id=c.question_id GROUP BY c.difficult_level ORDER BY correct_rate
0
点赞
评论
收藏
转发
害怕一个人的王老五是单身
2023-06-29 20:47
Java
题解 | #计算25岁以上和以下的用户数量#
SELECT CASE WHEN age<25 OR age IS NULL THEN '25岁以下' WHEN age>=25 THEN '25岁及以上' END age_cut,COUNT(*)number FROM user_profile GROUP BY age_cut;
0
点赞
评论
收藏
转发
害怕一个人的王老五是单身
2023-06-29 14:36
Java
题解 | #统计每个用户的平均刷题数#
SELECT a.university,c.difficult_level,COUNT(FORMAT(b.question_id,4))/COUNT(DISTINCT(b.device_id)) AS avg_answer_cnt FROM question_practice_detail AS b LEFT JOIN user_profile AS a ON a.device_id=b.device_id LEFT JOIN question_detail AS c ON b.question_id=c.question_id WHERE a.university='山东大学' GROUP ...
0
点赞
评论
收藏
转发
害怕一个人的王老五是单身
2023-06-29 14:25
Java
题解 | #统计每个学校各难度的用户平均刷题数#
SELECT a.university,c.difficult_level,COUNT(FORMAT(b.question_id,4))/COUNT(DISTINCT(b.device_id)) AS avg_answer_cnt FROM question_practice_detail AS b LEFT JOIN user_profile AS a ON a.device_id=b.device_id LEFT JOIN question_detail AS c ON b.question_id=c.question_id GROUP BY a.university,c.difficu...
0
点赞
评论
收藏
转发
害怕一个人的王老五是单身
2023-06-27 21:49
Java
题解 | #统计每个学校的答过题的用户的平均答题数#
SELECT a.university, FORMAT(COUNT(b.result)/COUNT(DISTINCT(b.device_id)),4) AS avg_answer_cnt FROM user_profile a,question_practice_detail b WHERE a.device_id=b.device_id GROUP BY a.university ORDER BY a.university
0
点赞
评论
收藏
转发
害怕一个人的王老五是单身
2023-06-27 20:40
Java
题解 | #计算男生人数以及平均GPA#
SELECT COUNT(gender) AS male_num,AVG(gpa) AS avg_gpa FROM user_profile WHERE gender='male' GROUP BY gender='male'
0
点赞
评论
收藏
转发
害怕一个人的王老五是单身
2023-06-27 16:27
Java
题解 | #纠错4#
SELECT cust_name,cust_contact,cust_email FROM Customers WHERE cust_state='MI' UNION SELECT cust_name,cust_contact,cust_email FROM Customers WHERE cust_state='IL' ORDER BY cust_name
0
点赞
评论
收藏
转发
害怕一个人的王老五是单身
2023-06-26 14:44
Java
题解 | #纠错4#
SELECT cust_name,cust_contact,cust_email FROM Customers WHERE cust_state='MI' UNION SELECT cust_name,cust_contact,cust_email FROM Customers WHERE cust_state='IL' ORDER BY cust_name
0
点赞
评论
收藏
转发
害怕一个人的王老五是单身
2023-06-25 20:13
Java
题解 | #返回顾客名称和相关订单号#
SELECT cust_name,order_num FROM Customers C,Orders O WHERE C.cust_id=O.cust_id ORDER BY cust_name ASC,order_num ASC;
0
点赞
评论
收藏
转发
害怕一个人的王老五是单身
2023-06-24 09:44
Java
题解 | #确定已售出产品项 BR01 的总数#
SELECT SUM(CONVERT(quantity,DECIMAL(10,3))) AS items_ordered FROM OrderItems WHERE prod_id='BR01'
0
点赞
评论
收藏
转发
害怕一个人的王老五是单身
2023-06-24 09:09
Java
题解 | #顾客登录名#
SELECT cust_id,cust_name,UPPER( CONCAT( SUBSTR((cust_contact),1,2),//注意substr是从1开始,substrb是从0开始,列名时要用括号 SUBSTR((cust_city),1,3) ) ) AS user_login FROM Customers;
0
点赞
评论
收藏
转发
害怕一个人的王老五是单身
2023-06-24 07:59
Java
题解 | #打折#
SELECT prod_id,prod_price,prod_price*0.9 AS sale_price FROM Products
0
点赞
评论
收藏
转发
害怕一个人的王老五是单身
2023-06-24 07:55
Java
题解 | #别名#
SELECT vend_id,vend_name AS vname ,vend_address AS vaddress,vend_city AS vcity FROM Vendors ORDER BY vname;
0
点赞
评论
收藏
转发
害怕一个人的王老五是单身
2023-06-24 07:41
Java
题解 | #检索产品名称和描述(一)#
SELECT prod_name,prod_desc FROM Products WHERE prod_desc LIKE '%toy%';
0
点赞
评论
收藏
转发
1
2
工具箱
TA的圈子
暂未加入圈子
TA的圈子
TA的笔记
暂无笔记
TA的笔记
登录
0
天
已登录
0
天
连续登录
0
人
今日访客
牛客网
牛客企业服务