What are the different work_types of news reporting?
select distinct work_type from news_report
How many reporters belong to each type?
select count(*), t2.work_type from journalist as t1 join news_report as t2 on t1.journalist_id = t2.journalist_id group by t2.work_type
What is the average age of the reporters for each type?
select avg(t1.age), t2.work_type from journalist as t1 join news_report as t2 on t1.journalist_id = t2.journalist_id group by t2.work_type
Also show the average number of years working for each type?
select avg(t1.age), avg(years_working), t2.work_type from journalist as t1 join news_report as t2 on t1.journalist_id = t2.journalist_id group by t2.work_type