摘要:
# Write your MySQL query statement belowSELECT DISTINCT f2.follower,f1.numFROM (SELECT followee, IFNULL(COUNT(DISTINCT followee,follower),0) AS numFRO 阅读全文
摘要:
SELECT c.Name AS CustomersFROM Customers cLEFT JOIN Orders oON c.Id = o.CustomerIdWHERE o.Id IS NULL 阅读全文
摘要:
# Write your MySQL query statement belowSELECT (MIN(ABS(p1.x-p2.x))) AS shortestFROM point p1LEFT JOIN point p2ON p1.x != p2.x 阅读全文
摘要:
SELECT EmailFROM PersonGROUP BY EmailHAVING COUNT(Email) >1; 阅读全文
摘要:
SELECT e.Name AS EmployeeFROM Employee eINNER JOIN Employee mON e.ManagerId = m.Id AND e.Salary > m.Salary; 阅读全文
摘要:
SELECT DISTINCT l1.Num AS ConsecutiveNumsFROM Logs l1,Logs l2,Logs l3WHERE l1.Id = l2.Id-1 AND l1.Id = l3.Id-2AND l1.Num =l2.Num AND l1.Num=l3.Num; 阅读全文
摘要:
# Write your MySQL query statement belowSELECT ROUND(MIN(SQRT(POW(p1.x-p2.x,2)+POW(p1.y-p2.y,2))),2) AS shortestFROM point_2d p1LEFT JOIN point_2d p2O 阅读全文
摘要:
SELECT s1.Score, (SELECT COUNT(DISTINCT s.Score) FROM Scores s WHERE s.Score >= s1.Score) AS RankFROM Scores s1ORDER BY s1.Score DESC; 阅读全文
摘要:
CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INTBEGIN DECLARE temp int; SET temp = N-1; RETURN ( # Write your MySQL query statement below. SELEC 阅读全文
摘要:
# Write your MySQL query statement belowSELECT *,(IF(x+y>z AND x+z>y AND y+z>x AND ABS(x-y)<z AND ABS(x-z)<y AND ABS(y-z)<x,'Yes','No')) AS triangleFR 阅读全文