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 vote307 views2 answers
Mysql select date from datetime
SQL
0 vote366 views2 answers
Mysql cast to varchar
SQL
0 vote299 views1 answer
Oracle list index on table
SQL
0 vote322 views1 answer
Mysql DDL
SQL
0 vote347 views1 answer
Update top 100 order by sql server
SQL
0 vote334 views1 answer
Mysql select random rows large table
SQL
1 vote307 views1 answer
Oracle index partition
SQL
1 vote333 views1 answer
OstgreSQL version
SQL
1 vote289 views1 answer
Mysqldump: couldn't execute 'select column_name,
SQL
0 vote331 views1 answer
Sql select upcoming birthdays
SQL