2016年8月28日
183. Customers Who Never Order
摘要： # Write your MySQL query statement below select Name Customers from Customers where Customers.Id not in ( select Customers.Id from Orders,Customers where Customers.Id=Orders.C... 阅读全文
posted @ 2016-08-28 11:06 阿怪123 阅读(89) 评论(0) 推荐(0)
181. Employees Earning More Than Their Managers
摘要： # Write your MySQL query statement below select E.name Employee from Employee as E,Employee as M where E.ManagerId=M.Id and E.Salary>M.Salary 阅读全文
posted @ 2016-08-28 10:57 阿怪123 阅读(120) 评论(0) 推荐(0)
182. Duplicate Emails
摘要： # Write your MySQL query statement below select distinct Email from Person group by Email having count(*) > 1 阅读全文
posted @ 2016-08-28 10:07 阿怪123 阅读(163) 评论(0) 推荐(0)