Show me all the research outcome.
select * from research_outcomes;
List those described with the substring 'Published' in the result.
select * from research_outcomes where outcome_description like '%published%';
How about the project details of the result?
select t1.project_details from projects as t1 join project_outcomes as t2 on t1.project_id = t2.project_id join research_outcomes as t3 on t2.outcome_code = t3.outcome_code where t3.outcome_description like '%published%';