摘要: # 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 阅读(86) 评论(0) 推荐(0) 编辑
摘要: # 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 阅读(112) 评论(0) 推荐(0) 编辑
摘要: # Write your MySQL query statement below select distinct Email from Person group by Email having count(*) > 1 阅读全文
posted @ 2016-08-28 10:07 阿怪123 阅读(155) 评论(0) 推荐(0) 编辑