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

1 vote263 views2 answers
Sql example query
SQL
0 vote261 views1 answer
Groupby error in mysql
SQL
0 vote265 views1 answer
Enable full text search mysql
SQL
5 votes266 views1 answer
Oracle get foreign keys on table
SQL
0 vote270 views1 answer
How to get data from 2 database
SQL
4 votes279 views6 answers
Sql select statement
SQL
1 vote260 views2 answers
Mssql show database size
SQL
9 votes259 views5 answers
Sql limit
SQL
10 votes238 views1 answer
Oracle dependency
SQL
1 vote262 views1 answer
Mysql change root mysql_native_password
SQL