摘要: 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 阅读全文
posted @ 2017-05-21 15:39 sixu 阅读(628) 评论(0) 推荐(0) 编辑
摘要: Source: https://leetcode.com/problems/trips-and-users/#/descriptionDescription: The Trips table holds all taxi trips. Each trip has a unique Id, while 阅读全文
posted @ 2017-05-21 15:30 sixu 阅读(261) 评论(0) 推荐(0) 编辑
摘要: Source: https://leetcode.com/problems/rising-temperature/#/descriptionDescription: Given a Weather table, write a SQL query to find all dates' Ids wit 阅读全文
posted @ 2017-05-21 15:25 sixu 阅读(148) 评论(0) 推荐(0) 编辑
摘要: Source: https://leetcode.com/problems/delete-duplicate-emails/#/descriptionDescription: Write a SQL query to delete all duplicate email entries in a t 阅读全文
posted @ 2017-05-21 15:08 sixu 阅读(162) 评论(0) 推荐(0) 编辑
摘要: Source: https://leetcode.com/problems/department-top-three-salaries/#/description Description: The Employee table holds all employees. Every employee 阅读全文
posted @ 2017-05-21 15:02 sixu 阅读(167) 评论(0) 推荐(0) 编辑
摘要: Source: https://leetcode.com/problems/department-highest-salary/#/descriptionDescription: The Employee table holds all employees. Every employee has a 阅读全文
posted @ 2017-05-21 14:59 sixu 阅读(180) 评论(0) 推荐(0) 编辑
摘要: Source: https://leetcode.com/problems/customers-who-never-order/#/descriptionDescription: Suppose that a website contains two tables, the Customers ta 阅读全文
posted @ 2017-05-21 14:55 sixu 阅读(126) 评论(0) 推荐(0) 编辑
摘要: Source: https://leetcode.com/problems/duplicate-emails/#/descriptionDescription: Write a SQL query to find all duplicate emails in a table named Perso 阅读全文
posted @ 2017-05-21 14:49 sixu 阅读(114) 评论(0) 推荐(0) 编辑
摘要: Source: https://leetcode.com/problems/employees-earning-more-than-their-managers/#/descriptionDescription: The Employee table holds all employees incl 阅读全文
posted @ 2017-05-21 14:36 sixu 阅读(197) 评论(0) 推荐(0) 编辑
摘要: Source: https://leetcode.com/problems/consecutive-numbers/#/descriptionDescription: Write a SQL query to find all numbers that appear at least three t 阅读全文
posted @ 2017-05-21 14:32 sixu 阅读(137) 评论(0) 推荐(0) 编辑
摘要: 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 阅读全文
posted @ 2017-05-21 14:07 sixu 阅读(266) 评论(0) 推荐(0) 编辑
摘要: Source: https://leetcode.com/problems/nth-highest-salary/#/descriptionDescription: Write a SQL query to get the nth highest salary from the Employee t 阅读全文
posted @ 2017-05-21 14:02 sixu 阅读(171) 评论(0) 推荐(0) 编辑
摘要: Source: https://leetcode.com/problems/second-highest-salary/#/description Description: Write a SQL query to get the second highest salary from the Emp 阅读全文
posted @ 2017-05-21 13:53 sixu 阅读(160) 评论(0) 推荐(0) 编辑
摘要: Source: https://leetcode.com/problems/combine-two-tables/#/description Description: Table: Person Table: Address Write a SQL query for a report that p 阅读全文
posted @ 2017-05-21 13:48 sixu 阅读(142) 评论(0) 推荐(0) 编辑