Zachos的博客

编写一个 SQL 查询，查找所有至少连续出现三次的数字。 # Write your MySQL query statement below SELECT distinct a1.Num as ConsecutiveNums from Logs a1,logs b1, logs c1 where a1.Id = b1.Id-1 and c1.Id = b1.Id+1 and a1.Num = b1.Num and b1.Num = c1.Num 点击链接 ...

从不订购的客户:某网站包含两个表，Customers 表和 Orders 表。编写一个 SQL 查询，找出所有从不订购任何东西的客户。 # Write your MySQL query statement below SELECT Customers.Name as Customers FROM Customers LEFT JOIN orders on Customers.Id <=> orders.CustomerId WHERE orders.CustomerId IS NULL;.

组合两个表 # Write your MySQL query statement below SELECT FirstName, LastName, City, State FROM Person LEFT JOIN Address ON Person.PersonId = Address.PersonId

超过5名学生的课:有一个courses 表 ，有: student (学生) 和 class (课程)。请列出所有超过或等于5名学生的课。 # Write your MySQL query statement below SELECT class FROM courses GROUP BY class HAVING count(distinct student) >= 5; ...

大的国家 # Write your MySQL query statement below SELECT name, population, area FROM World WHERE area > 3000000 or population > 25000000;

242.有效字母异位词：给定两个字符串 s 和 t ，编写一个函数来判断 t 是否是 s 的字母异位词。 解题思路：字母异位词就是各个字母的数目相同，而顺序不一致。判断两个字符串里的字母和其出现的次数，然后进行比较是否相等。这是一道微软的面试题，例如，“silent”和“listen”就是字母异位词。 class Solution: def isAnagram(self, s: str, t: str) -> bool: return Counter(s) == Counter