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 vote277 views1 answer
Sql server kill all connections
SQL
4 votes258 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
0 vote260 views1 answer
How to find database collation in postgres
SQL
0 vote282 views1 answer
Postgresql combine values in one field
SQL
11 votes295 views1 answer
Creating tables in sql with python
SQL
0 vote311 views1 answer
Sql to search who modified
SQL
0 vote279 views1 answer
Could not assemble any primary key columns for mapped table sqlalchemy
SQL
0 vote267 views1 answer
Oracle sql generate list of days
SQL
5 votes281 views2 answers
Postgres update with if condition query
SQL
0 vote277 views1 answer
Sql server set complex constraints
SQL