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 vote274 views1 answer
Primary key reset in SQL database
SQL
1 vote287 views1 answer
Get count by weekly pivot table sql server
SQL
0 vote266 views1 answer
Ms sql unique
SQL
0 vote259 views1 answer
Mysql create table columns with spaces
SQL
0 vote284 views1 answer
Mysql check datetime equals date
SQL
7 votes271 views4 answers
How to reset the identity column in sql server
SQL
1 vote283 views1 answer
Mysql f# examples
SQL
0 vote290 views2 answers
How do I install microsoft SQL on my Mac?
SQL
0 vote317 views1 answer
Mysql change default collation
SQL
0 vote290 views1 answer
Mssql now diff 90 day
SQL