what is average duration of all projects?
select avg(hours) from projects
what about the maximum and minimum duration?
select max(hours), min(hours) from projects
how many projects have operated longer than the average duration?
select count(*) from projects where hours > (select avg(hours) from projects)
what are their names?
select name from projects where hours > (select avg(hours) from projects)