Shoe me the names of all the journalists.
select name from journalist
Now include the names of all the events they each worked 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
How many did they each do?
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