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

1 vote392 views1 answer
Backup mysql schema only
SQL
1 vote382 views1 answer
Oracle nvl2
SQL
24 votes348 views4 answers
Mssql get all table names
SQL
8 votes347 views1 answer
Insert a select statement into a table
SQL
0 vote375 views2 answers
Sql last updated
SQL
0 vote344 views1 answer
How to find unique key in sql
SQL
0 vote354 views1 answer
Check duplicate values plsql
SQL
0 vote341 views1 answer
Mysql connection with sqlalchecmy
SQL
7 votes372 views2 answers
Postgres concat
SQL
0 vote365 views1 answer
Mysql undo delete
SQL