What type of organizations are there?
select organisation_type from organisation_types
And what is the organization ids detailed as "quo"?
select organisation_id from organisations where organisation_details = 'quo'
And what is this organization's type?
select t1.organisation_type from organisation_types as t1 join organisations as t2 on t1.organisation_type = t2.organisation_type where t2.organisation_details = 'quo'
And what is the total number of  RES organizations?
select count ( * ) from organisations where organisation_type = 'RES'