How many events have each journalists reported on?
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
How many journalists have 0 events!
select count(*) from journalist where journalist_id not in (select journalist_id from news_report)
What are their names?
select name from journalist where journalist_id not in (select journalist_id from news_report)