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 vote353 views1 answer
Postgresql stored procedure update table values
SQL
-1 vote325 views1 answer
What is in operator
SQL
3 votes325 views2 answers
Host is not allowed to connect to this mysql server
SQL
0 vote387 views1 answer
Hierarchal database table
SQL
6 votes309 views1 answer
How to count number of rows in sql
SQL
32 votes345 views6 answers
Sql count where
SQL
1 vote308 views1 answer
Oracle start job
SQL
6 votes332 views2 answers
Psql load dump
SQL
0 vote323 views1 answer
Query archive mode
SQL
20 votes311 views2 answers
Mysql bigint max value
SQL