摘要:
Source: https://leetcode.com/problems/big-countries/#/descriptionDescription: There is a table World A country is big if it has an area of bigger than 阅读全文
摘要:
Source: https://leetcode.com/problems/trips-and-users/#/descriptionDescription: The Trips table holds all taxi trips. Each trip has a unique Id, while 阅读全文
摘要:
Source: https://leetcode.com/problems/rising-temperature/#/descriptionDescription: Given a Weather table, write a SQL query to find all dates' Ids wit 阅读全文
摘要:
Source: https://leetcode.com/problems/delete-duplicate-emails/#/descriptionDescription: Write a SQL query to delete all duplicate email entries in a t 阅读全文
摘要:
Source: https://leetcode.com/problems/department-top-three-salaries/#/description Description: The Employee table holds all employees. Every employee 阅读全文
摘要:
Source: https://leetcode.com/problems/department-highest-salary/#/descriptionDescription: The Employee table holds all employees. Every employee has a 阅读全文
摘要:
Source: https://leetcode.com/problems/customers-who-never-order/#/descriptionDescription: Suppose that a website contains two tables, the Customers ta 阅读全文
摘要:
Source: https://leetcode.com/problems/duplicate-emails/#/descriptionDescription: Write a SQL query to find all duplicate emails in a table named Perso 阅读全文
摘要:
Source: https://leetcode.com/problems/employees-earning-more-than-their-managers/#/descriptionDescription: The Employee table holds all employees incl 阅读全文
摘要:
Source: https://leetcode.com/problems/consecutive-numbers/#/descriptionDescription: Write a SQL query to find all numbers that appear at least three t 阅读全文
摘要:
Source: https://leetcode.com/problems/rank-scores/#/description Description: Write a SQL query to rank scores. If there is a tie between two scores, b 阅读全文
摘要:
Source: https://leetcode.com/problems/nth-highest-salary/#/descriptionDescription: Write a SQL query to get the nth highest salary from the Employee t 阅读全文
摘要:
Source: https://leetcode.com/problems/second-highest-salary/#/description Description: Write a SQL query to get the second highest salary from the Emp 阅读全文
摘要:
Source: https://leetcode.com/problems/combine-two-tables/#/description Description: Table: Person Table: Address Write a SQL query for a report that p 阅读全文