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 vote211 views1 answer
Format the money fied with comma in international system using sql
SQL
2 votes218 views1 answer
Set boolean flasksql
SQL
0 vote229 views1 answer
Oracle sql add column auto generated value
SQL
37 votes290 views6 answers
Mysql update
SQL
1 vote234 views3 answers
Mysql parse int
SQL
1 vote220 views1 answer
How to use db.execute
SQL
50 votes240 views6 answers
Install mysql on ubuntu
SQL
0 vote218 views1 answer
Mysql undo delete
SQL
0 vote210 views1 answer
Shell script to log mysql cpu usage
SQL
1 vote235 views1 answer
Ora-01109 database not open in oracle 19c
SQL