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

8 votes180 views1 answer
Script to add datafile to tablespace
SQL
0 vote181 views1 answer
Add a new column into table
SQL
0 vote182 views1 answer
Select last 2 characters sql
SQL
0 vote193 views1 answer
Regex any word except sql
SQL
3 votes180 views1 answer
Unsigned int in mysql
SQL
5 votes187 views2 answers
Postgres update with if condition query
SQL
0 vote282 views1 answer
Multiple row join
SQL
1 vote167 views1 answer
Delete row mssql
SQL
0 vote179 views2 answers
Many to many flask-sqlalchemy
SQL
0 vote181 views1 answer
Change filed order in mysql
SQL