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 vote320 views1 answer
Truncate left characters mysql
SQL
0 vote346 views1 answer
Sql reverse order of results
SQL
1 vote307 views1 answer
Delete triger pl pg sql
SQL
0 vote355 views1 answer
Set Mamp mysql globally
SQL
0 vote366 views1 answer
000webhost database values insert
SQL
1 vote362 views1 answer
Oracle get current schema
SQL
0 vote367 views1 answer
Sql max of two values
SQL
3 votes338 views3 answers
C# sql select
SQL
3 votes379 views3 answers
Illuminate database queryexception could not find driver (sql select * from
SQL
0 vote354 views1 answer
Mysql show category once count how many products
SQL