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 vote216 views3 answers
Condition in count sql
SQL
0 vote337 views1 answer
How to find the most occuring in SQL
SQL
0 vote232 views1 answer
Sql query tags
SQL
0 vote191 views1 answer
How much table store postgres
SQL
0 vote191 views1 answer
Sql offfset
SQL
0 vote208 views2 answers
Mysql dump structure only
SQL
1 vote197 views2 answers
Test sqlsrv connection
SQL
15 votes191 views2 answers
Open postgress in terminal mac
SQL
0 vote190 views1 answer
Mysql xampp reset root password
SQL
0 vote180 views1 answer
SQL server select to get sum of hours
SQL