Which journalists have been working for less than 3 years?
select * from journalist where years_working < 3
Also add those that have been working for over 10!
select * from journalist where years_working < 3 or years_working > 10
What are their names?
select name from journalist where years_working < 3 or years_working > 10
Actually, list the different nations they are FROM!
select nationality from journalist where years_working > 10 intersect select nationality from journalist where years_working < 3