Lucas_Seven-CSDN博客

原创【SQL】LeetCode-Trips and Users

LeetCode 262：Trips and Users【Description】Write a SQL query to find the cancellation rate of requests made by unbanned users (both client and driver must be unbanned) between “2013-10-01” and “2013-10-03”.The cancellation rate is computed by dividing th

2021-01-28 12:38:20 142

原创【SQL】LeetCode-Rising Temperature

LeetCode 197：Rising Temperature【Description】Write an SQL query to find all dates’ id with higher temperature compared to its previous dates (yesterday).Return the result table in any order.The query result format is in the following example:【Solutio

2021-01-21 15:42:07 92

原创【SQL】LeetCode-Delete Duplicate Emails

LeetCode 196：Delete Duplicate Emails【Description】Write a SQL query to delete all duplicate email entries in a table named Person, keeping only unique emails based on its smallest Id.For example, after running your query, the above Person table should h

2021-01-21 15:18:10 94 1

原创【SQL】LeetCode-Department Top Three Salaries

LeetCode 185：Department Top Three Salaries【Description】The Employee table holds all employees. Every employee has an Id, and there is also a column for the department Id.The Department table holds all departments of the company.Write a SQL query to f

2021-01-18 15:38:31 87

原创【SQL】LeetCode-Department Highest Salary

LeetCode 184：Department Highest Salary【Description】The Employee table holds all employees. Every employee has an Id, a salary, and there is also a column for the department Id.The Department table holds all departments of the company.Write a SQL quer

2021-01-18 15:28:42 71

原创【SQL】LeetCode-Customers Who Never Order

LeetCode 183：Customers Who Never Order【Description】Suppose that a website contains two tables, the Customers table and the Orders table. Write a SQL query to find all customers who never order anything.Table: Customers.Table: Orders.Using the above

2021-01-15 16:52:23 76

原创【SQL】LeetCode-Duplicate Emails

LeetCode 182：Duplicate Emails【Description】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:Note: All emails are in lowercase.【Solution】Personal solution:

2021-01-15 16:41:49 109 1

原创【SQL】LeetCode-Employees Earning More Than Their Managers

LeetCode 181：Employees Earning More Than Their Managers【Description】The Employee table holds all employees including their managers. Every employee has an Id, and there is also a column for the manager Id.Given the Employee table, write a SQL query tha

2021-01-15 16:00:23 68

原创【SQL】LeetCode-Consecutive Numbers

LeetCode 180：Consecutive Numbers【Description】Write an SQL query to find all numbers that appear at least three times consecutively.Return the result table in any order.The query result format is in the following example:【Solution】SELECT DISTINCT l1.

2021-01-14 16:51:21 91

原创【SQL】LeetCode-Rank Scores

LeetCode 178：Rank Scores【Description】Write a SQL query to rank scores. If there is a tie between two scores, both should have the same ranking. Note that after a tie, the next ranking number should be the next consecutive integer value. In other words, t

2021-01-14 16:47:25 112 1

原创【SQL】LeetCode-Nth Highest Salary

LeetCode 177：Nth Highest Salary【Description】Write a SQL query to get the nth highest salary from the Employee table.For example, given the above Employee table, the nth highest salary where n = 2 is 200. If there is no nth highest salary, then the quer

2021-01-14 16:41:46 75

原创【SQL】LeetCode-Second Highest Salary

LeetCode 176：Combine Two Tables【Description】Write a SQL query to get the second highest salary from the Employee table.For example, given the above Employee table, the query should return 200 as the second highest salary. If there is no second highest

2021-01-14 16:38:49 57

qq_41515531的博客