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 vote190 views1 answer
Intellij idea add mysql connector
SQL
0 vote234 views1 answer
Reset a table's identity column and remove test records
SQL
7 votes185 views4 answers
How to reset the identity column in sql server
SQL
1 vote183 views1 answer
Sql dcl
SQL
0 vote184 views2 answers
Laravel: customize or extend notifications - database model
SQL
1 vote190 views1 answer
Mysql return if it contains
SQL
19 votes216 views1 answer
Sqrt(-1)
SQL
0 vote208 views1 answer
Ubuntu stop mysql from starting on boot
SQL
3 votes199 views2 answers
Mysql import gz
SQL
0 vote165 views1 answer
How to get initials in sql
SQL