leetcode中等题
文章平均质量分 57
小应的每天进步史
任何的被逼无奈,都只不过是不够强大
展开
-
585. 2016年的投资
# Write your MySQL query statement belowSELECT round(SUM(insurance.TIV_2016),2) AS TIV_2016FROM insuranceWHERE insurance.TIV_2015 IN ( SELECT TIV_2015 FROM insurance GROUP BY TIV_2015 HAVING COUNT.原创 2021-12-07 01:03:22 · 137 阅读 · 0 评论 -
580. 统计各专业学生人数
select dept_name , count(student_id) as student_number from department as A left outer join student as B on A.dept_id = B.dept_id group by A.dept_nameorder by student_number desc , dept_name一所大学有 2 个数据表,分别是student和department,这两个表保存着每个专业的学生数据...原创 2021-12-07 00:52:27 · 2150 阅读 · 0 评论 -
578. 查询回答率最高的问题
select A.question_id as survey_logfrom(select question_id , count(*) as answer_countfrom SurveyLogwhere action ='answer'group by question_id) as A # 先子表出来answer_countjoin (select question_id, count(*) as show_countfrom SurveyLogwhere action = '.原创 2021-12-07 00:43:52 · 208 阅读 · 0 评论 -
570. 至少有5名直接下属的经理
# Write your MySQL query statement belowSELECT NameFROM Employee AS t1 JOIN (SELECT ManagerId FROM Employee GROUP BY ManagerId HAVING COUNT(ManagerId) >= 5) AS t2 ON t1.Id = t2.ManagerId;Employee 表包含所有员工.原创 2021-12-05 08:11:05 · 101 阅读 · 0 评论 -
574. 当选者
select name from( select CandidateId from Votegroup by CandidateIdorder by count(*) Desc # 这里的vote表里是id 代表选民的id, candidateID 是和canditdate里面的id 是对应的limit 0,1) a join Candidate b on a.CandidateId = b.id表: Candidate+-----+---------+| id | Name ...原创 2021-12-02 02:48:15 · 120 阅读 · 0 评论 -
550. 游戏玩法分析 IV
SELECT ROUND( ( SELECT COUNT(DISTINCT a.player_id) FROM Activity a inner join ( select player_id, min(event_date) as first_day from Activity group by player_id ) as tm.原创 2021-12-02 02:47:24 · 88 阅读 · 0 评论 -
534. 游戏玩法分析 III
select a.player_id,b.event_date,sum(a.games_played) as games_played_so_farfrom Activity ainner join Activity b on a.player_id=b.player_id and a.event_date<=b.event_dategroup by b.player_id,b.event_date;Table:Activity+--------------+---------+|..原创 2021-12-02 02:46:33 · 85 阅读 · 0 评论