Mysql sum with group by

-- Sum Columns only show up in SELECT statement 
-- All other columns must be in both
SELECT categories_column, SUM(units_column) AS total_units
FROM schema.table
GROUP BY categories_column;

Similar codes

3 votes309 views5 answers
No module named 'MySQLdb'
SQL
2 votes287 views1 answer
How to delete columns in sql
SQL
3 votes246 views1 answer
Get all elements sql
SQL
0 vote282 views1 answer
Sql count null values in all columns
SQL
0 vote284 views1 answer
Adding generated time in row mysql workbench
SQL
0 vote312 views1 answer
Get total and distict row diff in sql
SQL
0 vote273 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
29 votes268 views6 answers
Delete all rows from table mysql
SQL
0 vote276 views1 answer
Template MySQL Zabbix agent
SQL
0 vote296 views1 answer
Oracle decode
SQL