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 vote139 views1 answer
Azure sql server check foreign key
SQL
2 votes167 views1 answer
Mariadb json select
SQL
1 vote141 views1 answer
Update foreign key value in mysql
SQL
0 vote161 views1 answer
Soql last week
SQL
4 votes131 views2 answers
Postgres update single column
SQL
0 vote143 views1 answer
Oracle webcenter content search enginer
SQL
0 vote162 views1 answer
Get create sql of hibernqte entity
SQL
1 vote140 views1 answer
Sql how to duplicate a table
SQL
0 vote158 views3 answers
Mysql regex replace
SQL
0 vote139 views1 answer
Load utilities in sql server
SQL