Sql练习搞起来！！！

收集的一些sql的题

 

 

 

 

 

 

not in解法 子查询
select customers.name as 'Customers'
from customers
where customers.id not in
(
select customerid from orders
);