Yes, I do
select name from journalist where nationality = "England"
and from Wales too
select name from journalist where nationality = "England" or nationality = "Wales"
How many journalists are from England or Wales ?
select count ( * ) from journalist where nationality = "England" or nationality = "Wales"
Can you show me their names ?
select name from journalist where nationality = "England" or nationality = "Wales"
How many journalists from England have worked for over an year ?
select count ( * ) from journalist where nationality = "England" and years_working > 1
What about Wales ?
select count ( * ) from journalist where nationality = "Wales" and years_working > 1
Yes
select name from journalist where nationality = "Wales" and years_working > 1 union select name from journalist where nationality = "England" and years_working > 1