Database: tracking_grants_for_research
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