What are names of all the different journalists that have reported on at least one event?
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 t1.journalist_id
For each, show the names of the events they 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
And also the venues and dates.
select t3.name, t2.name, t2.venue, t2.date 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
Now, show just the journalist names and dates of the events!
select t3.name, t2.date 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