- 博客(10)
- 收藏
- 关注
RSS订阅原创 Leetcode 1126. Active Businesses | SQL Pandas 解法
找到活跃的商家Write an SQL query to find all active businesses.An active business is a business that has more than one event type with occurences greater than the average occurences of that event type among all businesses.Table: Events+---------------+-------
2020-10-27 00:39:16
473
原创 Leetcode 1369. Get the Second Most Recent Activity | SQL Pandas 解法
1369. Get the Second Most Recent Activity返回最近的第二次活动Table: UserActivity+---------------+---------+| Column Name | Type |+---------------+---------+| username | varchar || activity | varchar || startDate | Date || endDate
2020-09-10 06:00:52
383
原创 Remove Linked List Elements 删除链表中的元素
删除链表中的元素删除链表中等于给定值 val 的所有节点。样例样例 1：输入：head = 1->2->3->3->4->5->3->null, val = 3输出：1->2->4->5->null样例 2：输入：head = 1->1->null, val = 1输出：null思路遍历整个链表，当遇到元素和给定数值相等，则跳过该node，将上一个node的next属性修改为当下这个node的next属性。所以
2020-08-10 03:54:14
265
原创 1075-1077 Project Employees I-III SQL Pandas 解析
Project Employees给了两个表project和employeeProject+-------------+-------------+| project_id | employee_id |+-------------+-------------+| 1 | 1 || 1 | 2 || 1 | 3 || 2 | 1
2020-07-10 07:36:05
222
原创 Leetcode 1417. Reformat The String Python3解法
Leetcode 1417. Reformat The String Python3解法Given alphanumeric string s. (Alphanumeric string is a string consisting of lowercase English letters and digits).You have to find a permutation of the string where no letter is followed by another letter and n
2020-06-15 07:31:38
207
原创 Leetcode 181. Employees Earning More Than Their Managers | SQL Pandas 解法
Leetcode 181. Employees Earning More Than Their Managers | SQL Pandas 解法EasyThe Employee table holds all employees including their managers. Every employee has an Id, and there is also a column for the manager Id.+----+-------+--------+-----------+| I
2020-06-10 04:34:47
233
原创 Leetcode 178. Rank Scores SQL Pandas解法
178. Rank Scores SQL Pandas解法SQL解法一：Window Function解法二：Using CountPandas可能的变形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 conse
2020-06-04 12:28:35
414
1
原创 Leetcode 177 Nth Highest Salary SQL Pandas解法
177. Nth Highest Salary SQL Pandas解法题目解法SQLPandas题目EasyWrite a SQL query to get the second highest salary from the Employee table.IdSalary110022003300For example, given the above Employee table, the query should return 200 as the
2020-06-03 03:23:30
296
原创 Leetcode 176 Second Highest Salary SQL Pandas解法
176. Second Highest Salary SQL Pandas解法题目解法SQL解法一解法二解法三Pandas题目EasyWrite a SQL query to get the second highest salary from the Employee table.IdSalary110022003300For example, given the above Employee table, the query should return
2020-06-02 05:21:07
336
原创 Leetcode 175 Combine Two Tables SQL Pandas解法
Leetcode 175 Combine Two Tables SQL Pandas解法用SQL和python合并数据表
2020-06-01 13:41:56
385
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人