How to write a SQL statement for grouping and summing?

You can achieve SQL grouping and summing by using the GROUP BY and SUM functions. Here is an example:

SELECT column1, SUM(column2)
FROM table
GROUP BY column1;

In the example above, “column1” is the column you want to group by, “column2” is the column you want to sum, and “table” is the name of the table you want to query. This statement will group by the values in the “column1” column and sum the values in the “column2” column for each group. The result will return the “column1” values for each group along with their corresponding sum.

Please make adjustments and modifications according to your specific needs.