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

3 votes185 views3 answers
Create table in SQL Server
SQL
2 votes163 views1 answer
Oracle sql merge
SQL
0 vote142 views1 answer
Sql make sure every user is unqiuew
SQL
1 vote137 views1 answer
Set id count mysql
SQL
5 votes185 views1 answer
Oracle sysdate - 1 month
SQL
0 vote146 views1 answer
Sqlalchemy query sql compiled
SQL
0 vote151 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
0 vote160 views1 answer
Mysql select where field is a value
SQL
0 vote145 views1 answer
18446744073709551615 mariadb left join order by
SQL
0 vote152 views1 answer
Android sqlite get rows count
SQL