Show the journalists with more than 10 years of working.
select * from journalist where years_working > 10
Show the name of journalists with more than 10 years of working and less than 3 years of working.
select name from journalist where years_working > 10 and years_working < 3
List the nations that have journalists with more than 10 years of working and journalists with less than 3 years of working.
select nationality from journalist where years_working > 10 intersect select nationality from journalist where years_working < 3
What is the average years of working for journalists from England.
select avg ( years_working ) from journalist where nationality = "England"
List the names of all journalists from England.
select name from journalist where nationality = "England"
What is the average age for all journalists from England.
select avg ( age ) from journalist where nationality = "England"