What projects are detailed as 'omnis'?
select * from tasks as t1 join projects as t2 on t1.project_id = t2.project_id where t2.project_details = 'omnis'
How many of these have more than 2 outcomes?
select count ( * ) from ( select t2.project_id from tasks as t1 join projects as t2 on t1.project_id = t2.project_id where t2.project_details = 'omnis' intersect select t2.project_id from tasks as t1 join projects as t2 on t1.project_id = t2.project_id join project_outcomes as t3 on t2.project_id = t3.project_id group by t2.project_id having count ( * ) > 2 )
How many projects (not labeled omnis) have two or more outcomes?
select count ( t2.project_id ) from tasks as t1 join projects as t2 on t1.project_id = t2.project_id join project_outcomes as t3 on t2.project_id = t3.project_id group by t2.project_id having count ( * ) > 2