What is the total grant amount of the organisations described as research?
create table organisation_types (organisation_type varchar, organisation_type_description varchar, PRIMARY KEY (organisation_type)); create table grants (organisation_id varchar, PRIMARY KEY (organisation_id)); create table organisations (organisation_id varchar, organisation_type varchar, PRIMARY KEY (organisation_id))
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'