Schema: CREATE TABLE Grants (organisation_id VARCHAR, grant_amount INTEGER)
Question: What is the total amount of grants given by each organisations? Also list the organisation id.
SQL: SELECT SUM(grant_amount), organisation_id FROM Grants GROUP BY organisation_id