183 从不订购的客户
题目链接:183.从不订购的客户
解答
select name as Customers from Customers where Customers.id not in (select customerId from Orders);
577 员工奖金
题目链接:577. 员工奖金
解答:
select Employee.name,Bonus.bonus from Employee left join Bonus on Employee.empId = Bonus.empId where Bonus.bonus < 1000 or Bonus.bonus is null;