About a year ago I learned database. Now I almost forgot. Here are some usage.
No.183
select Name as Customers
from Customers
where Id not in(
select CustomerId from Orders
);
No.182
select distinct Email
from Person
group by Email
having count(*)>1;