2018年08月_BigFatSheep

11月 10月 08月 06月 05月 04月 03月 02月 01月

原创 819. Most Common Word

问题描述 Given a paragraph and a list of banned words, return the most frequent word that is not in the list of banned words. It is guaranteed there is at least one word that isn’t banned, and that the ...

2018-08-12 14:34:10 197

原创 181. Employees Earning More Than Their Managers

问题描述 The Employee table holds all employees including their managers. Every employee has an Id, and there is also a column for the manager Id. +----+-------+--------+-----------+ | Id | Name | Sala...

2018-08-11 23:49:29 161

原创 627. Swap Salary

问题描述 Given a table salary, such as the one below, that has m=male and f=female values. Swap all f and m values (i.e., change all f values to m and vice versa) with a single update query and no interm...

2018-08-11 23:40:27 120

原创 178. Rank Scores

问题描述 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 v...

2018-08-11 21:32:21 162

原创 184. Department Highest Salary

问题描述 The Employee table holds all employees. Every employee has an Id, a salary, and there is also a column for the department Id. +----+-------+--------+--------------+ | Id | Name | Salary | Depa...

2018-08-11 21:13:26 222

原创 185. Department Top Three Salaries

2018-08-11 21:01:45 159

原创 595. Big Countries

2018-08-11 20:36:02 142

原创 709. To Lower Case

问题描述 Implement function ToLowerCase() that has a string parameter str, and returns the same string in lowercase. Example 1: Input: “Hello” Output: “hello” Example 2: Input: “here” Output: “here...

2018-08-11 20:21:20 198

空空如也

TA创建的收藏夹 TA关注的收藏夹

TA关注的人