What is the total amount of grants given by each organisations? Also list the organisation id.
CREATE TABLE Grants (organisation_id VARCHAR, grant_amount INTEGER)
SELECT SUM(grant_amount), organisation_id FROM Grants GROUP BY organisation_id
<s>[INST] Write mssql query to answer the following question given the database schema. 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. [/INST] SELECT SUM(grant_amount), organisation_id FROM Grants GROUP BY organisation_id </s>