SQL
Lucas_Seven
少年尚未配剑,转身已是江湖。
展开
-
【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 · 171 阅读 · 0 评论 -
【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 · 110 阅读 · 0 评论 -
【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 · 124 阅读 · 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 · 95 阅读 · 0 评论 -
【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 · 82 阅读 · 0 评论 -
【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 · 93 阅读 · 0 评论 -
【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 · 119 阅读 · 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 · 81 阅读 · 0 评论 -
【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 · 102 阅读 · 0 评论 -
【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 · 139 阅读 · 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 · 85 阅读 · 0 评论 -
【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 · 65 阅读 · 0 评论 -
【SQL】LeetCode-Combine Two Tables
Combine Two Tables【Description】Write a SQL query for a report that provides the following information for each person in the Person table, regardless if there is an address for each of those people:FirstName, LastName, City, State【Solution】select Fir原创 2021-01-14 16:33:05 · 89 阅读 · 0 评论