Give me the details of the organizations described as "Sponsor" in alphabetical 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
What about their IDs?
select organisation_id 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
How many are there?
select count ( organisation_id ) 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