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 vote205 views1 answer
Sql cursor example multiple columns
SQL
0 vote181 views1 answer
Flask sqlalchemy remove duplicates
SQL
26 votes137 views10 answers
Insert in to table sql
SQL
0 vote190 views1 answer
Sql on-premises
SQL
0 vote174 views1 answer
Oracle list of long running queries
SQL
0 vote212 views1 answer
Oracle pl/sql check if file exists
SQL
3 votes184 views3 answers
Start postgresql ubuntu
SQL
0 vote186 views1 answer
Postgres statistics
SQL
0 vote176 views1 answer
Criteria builder select subset of column
SQL
1 vote181 views2 answers
Postgresql get difference in hours between two dates
SQL