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 vote126 views1 answer
Trigger vérifier stock
SQL
8 votes122 views3 answers
Postgres connection string
SQL
0 vote119 views1 answer
Plsql check how much space all databases are consuming
SQL
1 vote112 views1 answer
Sql comment header
SQL
0 vote132 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL
10 votes71 views2 answers
Django mysql
SQL
1 vote142 views2 answers
This month mysql where
SQL
0 vote127 views1 answer
QUERY JPQL
SQL
0 vote112 views1 answer
Install mysql for fedora 34
SQL
0 vote117 views1 answer
Postgres populate table from another table
SQL