-- now find where city is null select * from orders where city is null; select * from orders where city is not null; -----Aggregation----- select count(*) as count ...