Show me all the journalist information for each journalist!
select * from journalist
What events have they each reported on.
select * 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
Count how many each journalist has worked 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
Show me just the names of the journalists that have reported on more than 1!
select t3.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 group by t3.name having count(*) > 1