Could you please tell me all the names of the journalists?
select name from journalist
What are the names of the events they reported?
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
Could you please organize those 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
What work type do those journalists do?
select t3.name, t1.work_type 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 years have they each been working, please?
select name,years_working from journalist