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

0 vote198 views1 answer
Show create table in postgresql
SQL
0 vote174 views1 answer
Big query add table rows to another table
SQL
0 vote196 views1 answer
Phpmyadmin tabellentyp ändern
SQL
1 vote230 views1 answer
Customer using hdfc bank sql query
SQL
0 vote197 views4 answers
Best data type to represent money in mysql
SQL
2 votes201 views1 answer
Oracle sql concatenate results into string
SQL
-1 vote224 views1 answer
Phinehas Psalm 106
SQL
0 vote204 views1 answer
First Step in installing SQL workbench
SQL
11 votes229 views6 answers
Mysql else if
SQL
0 vote198 views1 answer
Oracle last character of string
SQL