摘要： SELECT name AS Customers FROM Customers WHERE Customers.Id not in (SELECT DISTINCT CustomerId FROM Orders) 阅读全文

摘要： # Write your MySQL query statement below SELECT Email FROM #获取Email个数的表 (SELECT Email,COUNT(Email) AS c FROM Person GROUP BY Email) as e WHERE e.c>1 阅读全文

摘要： SELECT `name` as Employee FROM Employee AS e1, #获取一个还有经理id和Salary的表 (SELECT id,Salary FROM Employee WHERE id IN (SELECT ManagerId FROM Employee WHERE 阅读全文