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

16 votes228 views4 answers
Sort by sql
SQL
2 votes243 views1 answer
Sql OR
SQL
4 votes220 views1 answer
Mysql ip address
SQL
0 vote233 views1 answer
Sql server express download
SQL
1 vote240 views1 answer
Mysql show queries running
SQL
2 votes212 views1 answer
Mysql auto increment jumping
SQL
3 votes225 views5 answers
ModuleNotFoundError: No module named 'MySQLdb'
SQL
28 votes212 views4 answers
Mysql delete database
SQL
0 vote244 views1 answer
Apache Derby: Create SQL Dump with data
SQL
0 vote242 views1 answer
Get clob size oracle
SQL