What are all the event names?
select name from event
What were the event attendances for each one?
select name, event_attendance from event
Include the names of the journalist working on each event!
select t3.name, t2.name, t2.event_attendance 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
Show me just the names of the journalists and the event names in ascending order!
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 order by t2.event_attendance asc