Can you please list the names of the journalists in a table with the number of events they each reported?
select t3.name, count ( * ) from news_report as t1 join event as t2 on t1.event_id = t2.event_id join journalist as t3 on t1.journalist_id = t3.journalist_id group by t3.name
Can you add their ages and nationalities to the table please?
select t3.name, t3.age, t3.nationality, count ( * ) from news_report as t1 join event as t2 on t1.event_id = t2.event_id join journalist as t3 on t1.journalist_id = t3.journalist_id group by t3.name
What is the name of the event that the oldest journalist reported on?
select t3.name, t2.name from news_report as t1 join event as t2 on t1.event_id = t2.event_id join journalist as t3 on t1.journalist_id = t3.journalist_id where t3.age = ( select max ( age ) from journalist )