SQL Queries

 use classicmodels;

select * from offices;

select distinct(country) as unique_country

from offices;

select count(distinct country) as count_unique_country

from offices;

select country,state,phone

from offices

where state is not null;

select * 

from offices

where country='USA';

select * 

from offices

where country='USA' and state like '%a';

select * 

from offices

where country='USA' and state like '%a' and city like '__%n';