![](https://img-blog.csdnimg.cn/20201014180756916.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
LeetCode
SDS_19
这个作者很懒,什么都没留下…
展开
-
196. Delete Duplicate Emails
Problem:Write a SQL query todeleteall duplicate email entries in a table namedPerson, keeping only unique emails based on itssmallestId. +----+------------------+ | Id | Email | +----+------------------+ | 1 | john@example.com | | 2 | ...原创 2021-07-24 10:03:00 · 154 阅读 · 0 评论 -
620. Not Boring Movies
Problem:Write an SQL query to report the movies with an odd-numbered ID and a description that is not"boring". Return the result tablein descending order byrating. Cinema table: +----+------------+-------------+--------+ | id | movie | descripti...原创 2021-07-22 18:21:56 · 93 阅读 · 0 评论 -
596. Classes More Than 5 Students
Poblem:Please list out all classes which have more than or equal to 5 students. +---------+------------+ should output: +---------+ | student | class | | class | +---------+------------+ +---------+ | A .原创 2021-07-22 15:54:01 · 56 阅读 · 0 评论 -
197. Rising Temperature
Problem:Write an SQL query to find all dates'idwith higher temperature compared to its previous dates (yesterday). Return the result table inany order. The query result format is in the following example: Weather +----+------------+-------------+ |...原创 2021-07-18 10:52:13 · 122 阅读 · 0 评论 -
595. Big Countries
Problem:There is a table World. +-----------------+------------+------------+--------------+---------------+ | name | continent | area | population | gdp | +-----------------+------------+------------+--------------+--------原创 2021-07-17 10:36:40 · 142 阅读 · 0 评论 -
183. Customers Who Never Order
Problem: Suppose that a website contains two tables, theCustomerstable and theOrderstable. Write a SQL query to find all customers who never order anything. SELECT CustomerId FROM Orders; +------------+ | CustomerId | +------------+ | 3 | |...原创 2021-07-17 08:36:45 · 71 阅读 · 0 评论 -
182. Duplicate Emails
Problem: Write a SQL query to find all duplicate emails in a table named Person.For example, your query should return the following for the above table: +----+---------+ +---------+ | Id | Email | | Email | +----+---------+ +---------+ | 1 .原创 2021-07-16 20:57:39 · 50 阅读 · 0 评论