Sql sum show 0 result

# if WHERE... finds no rows, then sum(grade) == null, so returns an empty table
# Using COALESCE, if null, then values = 0, returns 1 row with value == 0
SELECT COALESCE(SUM(grade), 0) as sum FROM grades
WHERE project_title = 'Recipe Storage';

Similar codes

2 votes191 views1 answer
Drop table purge
SQL
1 vote236 views1 answer
Sql and
SQL
9 votes212 views4 answers
Mysql show table fields
SQL
0 vote226 views1 answer
Mysql join only one column
SQL
0 vote217 views1 answer
ACCEPT nome PROMPT on oracle
SQL
2 votes203 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
-1 vote224 views1 answer
SQL query to convert DD/MM/YYYY to YYYY-MM-DD
SQL
2 votes184 views1 answer
Mysql auto increment jumping
SQL
1 vote200 views2 answers
Postgresql list columns
SQL
2 votes226 views1 answer
Node and mysql like
SQL