What are the task details, task id and project id for the projects which are detailed as 'omnis' or  have more than 2 outcomes?
create table projects (project_id varchar, project_details varchar, PRIMARY KEY (project_id)); create table project_outcomes (project_id varchar, PRIMARY KEY (project_id)); create table tasks (task_details varchar, task_id varchar, project_id varchar, PRIMARY KEY (task_details))
select t1.task_details, t1.task_id, t2.project_id from tasks as t1 join projects as t2 on t1.project_id = t2.project_id where t2.project_details = 'omnis' union select t1.task_details, t1.task_id, 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