Hi, what journalist had worked the most amount of years?
select journalist_id from journalist order by years_working desc limit 1
Which journalist has worked the 2nd most amount of years?
select journalist_id from journalist where journalist_id not in ( select journalist_id from journalist order by years_working desc limit 1 ) order by years_working desc limit 1
Thank you, for the journalist with the ID of 4, what is his name?
select name from journalist where journalist_id = 4
Wonderful! What is her nationality?
select nationality from journalist where journalist_id = 4
Thank you! That's all I needed, but I'm also curious, how many journalists are from England?
select count ( journalist_id ) from journalist where nationality = 'England'
Which one has the least amount of years worked?
select journalist_id from journalist where nationality = 'England' order by years_working limit 1
Awesome, Im almost done, but can you tell me overall who worked the least amount of years as well?
select journalist_id from journalist order by years_working limit 1