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 vote148 views1 answer
To_date sql
SQL
18 votes133 views6 answers
Creating table in MySQL
SQL
0 vote135 views1 answer
Utiliser sql ligne de commande
SQL
0 vote127 views1 answer
Call rest api from postgresql
SQL
1 vote146 views2 answers
How to combine 2 tables in MySQL
SQL
14 votes136 views2 answers
Sql cast
SQL
1 vote160 views2 answers
Changes not showing on website server odoo
SQL
0 vote143 views2 answers
How to get last inserted id in sql server c#
SQL
0 vote128 views2 answers
Select limit ms sql
SQL
0 vote129 views1 answer
Postgresql stored procedure update table values
SQL