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

5 votes264 views3 answers
Create function in postgresql
SQL
0 vote214 views1 answer
Sql date time query find
SQL
0 vote206 views3 answers
Query string not ending with with vowels
SQL
1 vote194 views1 answer
Drop table if exists oracle
SQL
7 votes232 views4 answers
Database dump mysql command
SQL
0 vote218 views1 answer
No query unable to fetch row sqlite
SQL
-2 votes214 views1 answer
Mysql see users and passwords
SQL
0 vote214 views1 answer
Least spark sql
SQL
1 vote198 views1 answer
Date_part mysql
SQL
1 vote349 views1 answer
Mysql data from file
SQL