Show me the grant amount of the organisations described as sponser?
select grant_amount from grants as t1 join organisations as t2 on t1.organisation_id = t2.organisation_id join organisation_types as t3 on t2.organisation_type = t3.organisation_type where t3.organisation_type_description = 'Sponsor';
How about the organisations described as research?
select grant_amount from grants as t1 join organisations as t2 on t1.organisation_id = t2.organisation_id join organisation_types as t3 on t2.organisation_type = t3.organisation_type where t3.organisation_type_description = 'Research';
Show me the sum of the result.
select sum(grant_amount) from grants as t1 join organisations as t2 on t1.organisation_id = t2.organisation_id join organisation_types as t3 on t2.organisation_type = t3.organisation_type where t3.organisation_type_description = 'Research';