Show me all the details of organisations.
select organisation_details from organisations;
Among the result, which ones are described as 'Sponsor'?
select organisation_details from organisations as t1 join organisation_types as t2 on t1.organisation_type = t2.organisation_type where t2.organisation_type_description = 'Sponsor';
Sort the result in an ascending order.
select organisation_details from organisations as t1 join organisation_types as t2 on t1.organisation_type = t2.organisation_type where t2.organisation_type_description = 'Sponsor' order by organisation_details asc;