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

22 votes137 views4 answers
Mysql format date
SQL
0 vote243 views1 answer
Power bi connect to postgresql
SQL
4 votes104 views2 answers
Tables in sql
SQL
3 votes57 views1 answer
System.debug apex
SQL
0 vote107 views1 answer
Declare or use variable in snowflake
SQL
0 vote91 views1 answer
Cast for print sql
SQL
-1 vote110 views8 answers
Sql to c# linq converter online
SQL
4 votes109 views1 answer
Oracle user tables
SQL
0 vote98 views1 answer
Mysql search like but first exact match
SQL
4 votes227 views1 answer
Oracle table statistics
SQL