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 vote165 views1 answer
Can we rollback data that are deleted using DELETE
SQL
0 vote170 views1 answer
First mysql
SQL
0 vote194 views2 answers
Sql auto update dupdated_at
SQL
0 vote174 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL
0 vote205 views1 answer
Show all sequences postgres
SQL
0 vote199 views1 answer
Implode in sql query
SQL
3 votes180 views2 answers
Sql asc
SQL
0 vote193 views1 answer
Select nth row in mysql
SQL
0 vote179 views1 answer
Postgresql in vs any performance
SQL
1 vote174 views1 answer
Lpad function in sql oracle
SQL