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 vote190 views2 answers
Py sqlite if entry exists
SQL
1 vote195 views1 answer
How to check the mysql version mac
SQL
-1 vote207 views1 answer
Mysql delete duplicate rows except one
SQL
0 vote187 views1 answer
Groupby sort sql hive
SQL
0 vote192 views1 answer
Drop-toys-table
SQL
11 votes185 views2 answers
Oracle source code
SQL
2 votes220 views1 answer
Sql update \
SQL
1 vote174 views2 answers
Into sql
SQL
1 vote208 views3 answers
How to pass password to mysql command line
SQL
0 vote285 views1 answer
SQL query to verify the size of the table
SQL