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

1 vote274 views1 answer
Firebase bigquery cloud message
SQL
1 vote277 views10 answers
Stack overflow
SQL
1 vote311 views1 answer
Mysql size int
SQL
8 votes296 views1 answer
Show mysql user table
SQL
0 vote317 views1 answer
Replace divide by zero error with 0 in sql
SQL
4 votes303 views1 answer
Datepart postgres
SQL
3 votes331 views1 answer
Sql double index
SQL
1 vote311 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
-1 vote309 views1 answer
How to change the auto increment in existing table mysql
SQL
0 vote325 views1 answer
Sql create and grant user access to database
SQL