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 vote361 views1 answer
Oracle query archivemode
SQL
14 votes412 views5 answers
Set password for postgres user ubuntu
SQL
1 vote358 views1 answer
Ubuntu access database from terminal
SQL
1 vote363 views1 answer
Postgresql delete cascade
SQL
3 votes342 views1 answer
How to check schema privileges in oracle
SQL
4 votes367 views4 answers
Sqlite describe table
SQL
0 vote325 views1 answer
Sql truncate table referencing itself
SQL
13 votes389 views2 answers
Get date from now() mysql
SQL
1 vote412 views1 answer
Postgresql if 0 then 1
SQL
1 vote349 views1 answer
Create temporal table in sql
SQL