Leetcode数据库Mysql-Easy
Leetcode数据库Mysql-Easy
Love 6
腾讯WXG在职后台小鹅
展开
-
Leetcode Mysql 610. 判断三角形(DAY 20)
文章目录原题题目代码实现(首刷自解)原题题目代码实现(首刷自解)# Write your MySQL query statement belowSELECT x,y,z,IF(x+y>z AND x+z>y AND y+z>x,"Yes","No") AS triangleFROM triangle原创 2021-11-01 22:12:20 · 182 阅读 · 0 评论 -
Leetcode Mysql 196. 删除重复的电子邮箱(DAY 19)
文章目录原题题目代码实现(首刷思路清楚 Delete语法看解)原题题目代码实现(首刷思路清楚 Delete语法看解)# Write your MySQL query statement belowDELETEFROM personwhere id NOT IN (SELECT id FROM (SELECT MIN(id) AS ID FROM person原创 2021-11-01 15:08:45 · 117 阅读 · 0 评论 -
Leetcode Mysql 1407. 排名靠前的旅行者(DAY 19)
文章目录原题题目代码实现(首刷自解)原题题目代码实现(首刷自解)# Write your MySQL query statement belowSELECT name,IFNULL(SUM(distance),0) AS travelled_distanceFROM users AS u LEFT JOIN rides AS r ON u.id = r.user_idGROUP BY user_idORDER BY travelled_distance DESC,name ..原创 2021-11-01 14:49:29 · 124 阅读 · 0 评论 -
Leetcode Mysql 603. 连续空余座位(DAY 18)
文章目录原题题目代码实现(首刷大部分看解 明天再做了)原题题目代码实现(首刷大部分看解 明天再做了)# Write your MySQL query statement belowSELECT DISTINCT(c1.seat_id)FROM cinema AS c1 JOIN cinema AS c2 ON ABS(c2.seat_id - c1.seat_id) = 1WHERE c1.free = 1 AND c2.free = 1ORDER BY c1.seat_id.原创 2021-10-31 12:40:16 · 177 阅读 · 0 评论 -
Leetcode Mysql 183. 从不订购的客户(DAY 18)
文章目录原题题目代码实现(首刷自解)原题题目代码实现(首刷自解)# Write your MySQL query statement belowSELECT name AS customers FROM customersWHERE id NOT IN (SELECT customerid FROM Orders)原创 2021-10-31 11:44:43 · 109 阅读 · 0 评论 -
Leetcode Mysql 1511. 消费者下单频率(DAY 17)
文章目录原题题目代码实现(首刷自解)原题题目代码实现(首刷自解)# Write your MySQL query tatement belowSELECT customer_id,nameFROM (SELECT customer_id,DATE_FORMAT(order_date,"%Y-%m") AS date FROM orders LEFT JOIN product USING(product_id) WHERE DATE_FORMAT(ord原创 2021-10-30 21:09:11 · 191 阅读 · 0 评论 -
Leetcode Mysql 1327. 列出指定时间段内所有的下单产品(DAY 16)
文章目录原题题目代码实现(首刷自解)原题题目代码实现(首刷自解)# Write your MySQL query statement belowSELECT product_name,unitFROM (SELECT product_id,SUM(unit) AS unit FROM orders WHERE DATE_FORMAT(order_date,"%Y-%m") = "2020-02" GROUP BY product_id原创 2021-10-21 15:34:52 · 140 阅读 · 0 评论 -
Leetcode Mysql 1075. 项目员工 I(DAY 15)
文章目录原题题目代码实现(首刷自解)原题题目代码实现(首刷自解)# Write your MySQL query statement belowSELECT project_id,ROUND(SUM(experience_years) / COUNT(*),2) AS average_yearsFROM project LEFT JOIN employee USING(employee_id)GROUP BY project_id...原创 2021-10-18 09:58:55 · 100 阅读 · 0 评论 -
Leetcode Mysql 577. 员工奖金(DAY 15)
文章目录原题题目代码实现(首刷自解)原题题目代码实现(首刷自解)# Write your MySQL query statement belowSELECT e.name,b.bonusFROM employee AS e LEFT JOIN bonus AS b USING(empID)WHERE bonus < 1000 or bonus is NULL...原创 2021-10-18 09:18:26 · 113 阅读 · 0 评论 -
Leetcode Mysql 181. 超过经理收入的员工(DAY 14)
文章目录原题题目代码实现(首刷自解)原题题目代码实现(首刷自解)# Write your MySQL query statement belowSELECT e1.name AS EmployeeFROM employee e1 JOIN employee e2 ON e1.managerid = e2.idWHERE e1.salary > e2.salary...原创 2021-10-15 12:41:37 · 87 阅读 · 0 评论 -
Leetcode Mysql 1789. 员工的直属部门(DAY 12)
文章目录原题题目代码实现(首刷自解)原题题目代码实现(首刷自解)# Write your MySQL query statement belowSELECT employee_id,department_idFROM employee AS eGROUP BY employee_idHAVING COUNT(*) = 1 UNIONSELECT employee_id,department_idFROM employee AS eWHERE primary_flag =原创 2021-10-12 13:28:10 · 186 阅读 · 0 评论 -
Leetcode Mysql 1890. 2020年最后一次登录(DAY 12)
文章目录原题题目代码实现(首刷自解)原题题目代码实现(首刷自解)# Write your MySQL query statement belowSELECT user_id,time_stamp AS last_stampFROM (SELECT user_id,time_stamp,RANK() OVER(PARTITION BY user_id ORDER BY time_stamp DESC) AS rnk FROM logins WHERE y原创 2021-10-12 13:19:37 · 112 阅读 · 0 评论 -
Leetcode Mysql 1148. 文章浏览 I(DAY 11)
文章目录原题题目代码实现(首刷自解)原题题目代码实现(首刷自解)# Write your MySQL query statement belowSELECT DISTINCT author_id AS idFROM viewsWHERE author_id = viewer_idORDER BY 1原创 2021-10-11 14:38:27 · 141 阅读 · 0 评论 -
Leetcode Mysql 1517. 查找拥有有效邮箱的用户(DAY 9)---- 正则表达式匹配
文章目录原题题目代码实现(首刷自解)原题题目代码实现(首刷自解)# Write your MySQL query statement belowSELECT *FROM users AS uWHERE mail regexp '^[a-zA-Z][a-zA-Z0-9_\\.-]*@leetcode.com$'原创 2021-10-09 12:32:17 · 279 阅读 · 0 评论 -
Leetcode Mysql 511. 游戏玩法分析 I(DAY 9)
文章目录原题题目代码实现(首刷自解)原题题目代码实现(首刷自解)# Write your MySQL query statement belowSELECT a.player_id,a.event_date AS first_loginFROM (SELECT player_id,event_date,RANK() OVER(PARTITION BY player_id ORDER BY event_date) AS ranking FROM activity) aWH原创 2021-10-09 12:18:52 · 851 阅读 · 0 评论 -
Leetcode Mysql 1050. 合作过至少三次的演员和导演(DAY 6)
文章目录原题题目代码实现(首刷自解)原题题目代码实现(首刷自解)# Write your MySQL query statement belowSELECT actor_id,director_idFROM actordirectorGROUP BY actor_id,director_idHAVING COUNT(*) >= 3原创 2021-10-03 12:54:51 · 118 阅读 · 0 评论 -
Leetcode Mysql 1173. 即时食物配送 I(DAY 6)
文章目录原题题目代码实现(首刷自解)原题题目代码实现(首刷自解)# Write your MySQL query statement belowSELECT ROUND(COUNT(*)/(SELECT COUNT(*) FROM delivery)*100,2) AS immediate_percentageFROM deliveryWHERE order_date = customer_pref_delivery_date...原创 2021-10-03 12:51:27 · 2183 阅读 · 0 评论 -
Leetcode Mysql 1571. 仓库经理(DAY 6)
文章目录原题题目代码实现(首刷自解)原题题目代码实现(首刷自解)# Write your MySQL query statement belowSELECT name AS WAREHOUSE_NAME,SUM(units*width*length*height) AS VOLUMEFROM warehouse AS w join products AS p on w.product_id = p.product_idGROUP BY name...原创 2021-10-03 12:46:57 · 161 阅读 · 0 评论 -
Leetcode Mysql 1082. 销售分析 I(DAY 6)
文章目录原题题目代码实现(首刷自解)原题题目代码实现(首刷自解)# Write your MySQL query statement belowSELECT seller_idFROM salesGROUP BY seller_idHAVING SUM(price) >= ALL(SELECT SUM(price) FROM sales GROUP BY seller_id)...原创 2021-10-03 12:32:52 · 126 阅读 · 0 评论 -
Leetcode Mysql 1251. 平均售价(DAY 7)
文章目录原题题目代码实现(首刷自解)原题题目代码实现(首刷自解)# Write your MySQL query statement belowSELECT p.product_id, ROUND(SUM(price*units) / SUM(units),2) average_priceFROM prices p INNER JOIN unitssold u on p.product_id = u.product_idWHERE u.purchase_原创 2021-10-04 17:52:21 · 143 阅读 · 0 评论 -
Leetcode Mysql 620. 有趣的电影(DAY 7)
文章目录原题题目代码实现(首刷自解)原题题目代码实现(首刷自解)# Write your MySQL query statement belowSELECT id,movie,description,ratingFROM cinemaWHERE description <> "boring" and id%2 <> 0ORDER BY rating DESC...原创 2021-10-04 17:51:59 · 109 阅读 · 0 评论 -
Leetcode Mysql 1777. 每家商店的产品价格(DAY 5)
文章目录原题题目代码实现(首刷自解)代码实现(首刷理解SUM IF)原题题目代码实现(首刷自解)# Write your MySQL query statement belowSELECT p.product_id, s1.price store1, s2.price store2, s3.price store3FROM (SELECT distinct product_id FROM products ) pleft join (S原创 2021-10-02 12:05:34 · 143 阅读 · 0 评论 -
Leetcode Mysql 1623. 三人国家代表队(DAY 7)
文章目录原题题目代码实现(首刷自解)原题题目代码实现(首刷自解)# Write your MySQL query statement belowSELECT a.student_name member_A, b.student_name member_B, c.student_name member_CFROM schoolA a join schoolB b join schoolC cWHERE a.student_原创 2021-10-04 17:51:49 · 195 阅读 · 0 评论 -
Leetcode Mysql 1795. 每个产品在不同商店的价格(DAY 5)
文章目录原题题目代码实现(首刷看了点提示 - - 忘了UNION了)原题题目代码实现(首刷看了点提示 - - 忘了UNION了)# Write your MySQL query statement belowSELECT product_id,'store1' store,store1 priceFROM productsWHERE store1 is not nullUNIONSELECT product_id,'store2' store原创 2021-10-02 12:05:24 · 210 阅读 · 0 评论 -
Leetcode Mysql 595. 大的国家(DAY 5)
文章目录原题题目代码实现(首刷自解)原题题目代码实现(首刷自解)# Write your MySQL query statement belowSELECT name, population, areaFROM worldWHERE area >= 3000000 or population >= 25000000...原创 2021-10-02 12:05:09 · 101 阅读 · 0 评论 -
Leetcode Mysql 182. 查找重复的电子邮箱(DAY 8)
文章目录原题题目代码实现(首刷自解)原题题目代码实现(首刷自解)# Write your MySQL query statement belowSELECT DISTINCT p1.email EmailFROM person p1 JOIN person p2WHERE p1.id < p2.id and p1.email = p2.email...原创 2021-10-08 12:22:07 · 128 阅读 · 0 评论 -
Leetcode Mysql 1693. 每天的领导和合伙人(DAY 4)
文章目录原题题目代码实现(首刷自解)原题题目代码实现(首刷自解)# Write your MySQL query statement belowSELECT date_id,make_name,COUNT(distinct lead_id) unique_leads,COUNT(distinct partner_id)unique_partnersFROM dailysalesGROUP BY date_id,make_name...原创 2021-10-01 11:24:42 · 133 阅读 · 0 评论 -
Leetcode Mysql 1873. 计算特殊奖金(DAY 4)
文章目录原题题目代码实现(首刷自解)原题题目代码实现(首刷自解)# Write your MySQL query statement belowSELECT employee_id,if(employee_id%2 = 0 or name like 'M%',0,salary) bonusFROM employees原创 2021-10-01 11:24:19 · 145 阅读 · 0 评论 -
Leetcode Mysql 627. 变更性别(DAY 3)
文章目录原题题目代码实现(首刷自解 首次使用if)原题题目代码实现(首刷自解 首次使用if)# Write your MySQL query statement belowUPDATE salarySET sex = if(sex='f','m','f')原创 2021-09-30 19:18:23 · 124 阅读 · 0 评论 -
Leetcode Mysql 1581. 进店却未进行过交易的顾客(DAY 3)
文章目录原题题目代码实现(首刷自解)原题题目代码实现(首刷自解)# Write your MySQL query statement belowSELECT customer_id,(count(*)) count_no_transFROM (SELECT customer_id,transaction_id FROM visits v left join transactions t on v.visit_id = t.visit_id) tmpWHERE tra原创 2021-09-30 19:18:11 · 128 阅读 · 0 评论 -
Leetcode Mysql 1285. 找到连续区间的开始和结束数字(DAY 3)
文章目录原题题目代码实现(首刷大部分看解 学习思路)原题题目代码实现(首刷大部分看解 学习思路)# Write your MySQL query statement belowSELECT a.log_id start_id,min(b.log_id) end_idFROM (SELECT log_id FROM logs WHERE log_id-1 not in(SELECT* FROM logs)) a, (SELECT log_id FROM logs WHER原创 2021-09-30 17:04:23 · 165 阅读 · 0 评论 -
Leetcode Mysql 613. 直线上的最近距离(DAY 3)
文章目录原题题目代码实现(首刷自解)原题题目代码实现(首刷自解)# Write your MySQL query statement belowSELECT min(dif) shortestFROM (SELECT (p1.x - p2.x) dif FROM point p1,point p2 WHERE p1.x > p2.x) t...原创 2021-09-30 17:04:09 · 103 阅读 · 0 评论 -
Leetcode Mysql 1069. 产品销售分析 II(DAY 3)
文章目录原题题目代码实现(首刷自解)原题题目代码实现(首刷自解)# Write your MySQL query statement belowSELECT product_id,(SUM(quantity)) total_quantityFROM salesGROUP BY product_id原创 2021-09-30 17:04:00 · 119 阅读 · 0 评论 -
Leetcode Mysql 1303. 求团队人数(DAY 3)
文章目录原题题目代码实现(首刷自解)原题题目代码实现(首刷自解)# Write your MySQL query statement belowSELECT employee_id,team_sizeFROM employee e,(SELECT team_id,count(*) team_size FROM employee GROUP BY team_id) tWHERE e.team_id = t.team_id; ...原创 2021-09-30 17:03:48 · 134 阅读 · 0 评论 -
Leetcode Mysql 1587. 银行账户概要 II(DAY 3)
文章目录原题题目代码实现(首刷自解)原题题目代码实现(首刷自解)# Write your MySQL query statement belowSELECT name,SUM(amount) balanceFROM users u join transactions t on u.account = t.account GROUP BY t.account having balance > 10000...原创 2021-09-30 17:03:35 · 130 阅读 · 0 评论 -
Leetcode Mysql 1741. 查找每个员工花费的总时间(DAY 2)
文章目录原题题目代码实现(首刷自解)原题题目代码实现(首刷自解)# Write your MySQL query statement belowSELECT event_day day,emp_id,(SUM(out_time) - SUM(in_time)) total_timeFROM employeesGROUP BY emp_id,event_day...原创 2021-09-29 17:00:47 · 125 阅读 · 0 评论 -
Leetcode Mysql 1350. 院系无效的学生(DAY 2)
文章目录原题题目代码实现(首刷自解)原题题目代码实现(首刷自解)# Write your MySQL query statement belowSELECT id,nameFROM students sWHERE s.department_id not IN (SELECT id FROM departments)原创 2021-09-29 12:51:39 · 129 阅读 · 0 评论 -
Leetcode Mysql 1068. 产品销售分析 I(DAY 1)
文章目录原题题目代码实现(首刷自解)原题题目代码实现(首刷自解)# Write your MySQL query statement belowselect product_name,year,pricefrom product inner join sales on sales.product_id = product.product_id原创 2021-09-28 15:32:35 · 143 阅读 · 0 评论 -
Leetcode Mysql 1821. 寻找今年具有正收入的客户(DAY 1)
文章目录原题题目代码实现(首刷自解)原题题目代码实现(首刷自解)# Write your MySQL query statement belowselect customer_idfrom customerswhere year = 2021 and revenue > 0原创 2021-09-28 15:15:40 · 126 阅读 · 0 评论 -
Leetcode Mysql 1757. 可回收且低脂的产品(DAY 1)
文章目录原题题目代码实现(首刷自解)原题题目代码实现(首刷自解)# Write your MySQL query statement belowselect product_idfrom productswhere low_fats = 'Y' and recyclable = 'Y'原创 2021-09-28 15:12:09 · 149 阅读 · 0 评论