自从地里没了缺米的刷题接龙就懒了，开个帖子和小伙伴自发打卡好了

今天从200题以后开始刷，之前的其实还没总结，就周六日总结一下吧
201    Bitwise AND of Numbers Range

202    Happy Number

203    Remove Linked List Elements

分别是bit，hashtable和linkedlist

---

本帖被14417335扣分。扣分情况：-5，理由：。
提醒：对于骂人、戾气、广告等行为，请勿对骂，请举报。

今天的三题~
继续过sql
175：Combine Two Tables
SELECT FirstName, LastName, City, State
FROM Person LEFT JOIN Address on Person.PersonId = Address.PersonId
176：Second Highest Salary
SELECT max(Salary) AS SecondHighestSalary
FROM Employee
WHERE Salary < (SELECT max(Salary) FROM Employee)
177：Nth Highest Salary
CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
BEGIN
DECLARE M INT;
SET M=N-1;
  RETURN (
      # Write your MySQL query statement below.
      SELECT DISTINCT Salary FROM Employee ORDER BY Salary DESC LIMIT M, 1
  );
END

我打卡两个sql吧！
180： Consecutive Numbers

select distinct l1.Num ConsecutiveNums
from Logs l1, Logs l2, Logs l3
where   l1.Id+1 = l2.Id
    and l2.Id+1 = l3.Id
    and l1.Num  = l2.Num
    and l2.Num  = l3.Num

181： Employees Earning More Than Their Managers

select a.Name as Employee from Employee a inner join Employee b on a.ManagerId = b.Id
where a.Salary > b.Salary

182：Duplicate Emails

SELECT DISTINCT p1.email
FROM Person p1
JOIN
(SELECT email, COUNT(*)
from Person
GROUP BY email
HAVING COUNT(*) > 1
) p2
ON p1.email = p2.email;

wen jun fan 发表于 2020-12-10 14:59
我现在的页面长这样~为啥？

我看了一下两小时前这个帖子被地里的管理员移动了现在我们在打卡战拖板块，这个板块全部无法加米，其他板块可以～所以你不是一个人～

12/08/2020开始打卡如果每天可以做3题12/31前就可以做23*3 69题，一共还剩6个周末复习前两百题周末除了3题新题，复习33题~加油加油~

楼主加我一个 12.9打卡 三道dp的题目

多谢楼主！我也来post一下前两天做的。求加米！

我也来打个卡
昨天刷的题
求米求米！

我也打个卡 这两天final没怎么刷 接下来要继续努力了

今天打卡: hashtable和linkedlist都是easy等级的
204. Count Primes
205. Isomorphic Strings
206. Reverse Linked List

lunatic_luna 发表于 2020-12-10 12:04
我也来打个卡
昨天刷的题
求米求米！

忽然不能评分加米了你们也是吗?