1 OSA
1.

SELECT c.country_name, c.country_id, r.region_name from regions r, countries c 
where country_name not like 'I%' 
and country_name not like 'A%'
and r.region_id !=1


2.

SELECT l.city, l.state_province, c.country_name from locations l, countries c
where state_province != 'NULL'