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

8 votes128 views10 answers
Sql
SQL
0 vote108 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL
0 vote134 views1 answer
Mysql group by range
SQL
4 votes226 views6 answers
Laravel jwt
SQL
0 vote133 views1 answer
Sql remove non numeric characters
SQL
6 votes132 views4 answers
Mysql group by date
SQL
3 votes157 views2 answers
@sqlresultsetmapping
SQL
0 vote127 views1 answer
Postgresql create query
SQL
14 votes115 views3 answers
Delete all records from table except sql
SQL
0 vote124 views1 answer
Prodection ready postgres database step by step
SQL