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 vote125 views1 answer
Select from column mysql
SQL
1 vote124 views1 answer
Oracle check table space
SQL
1 vote126 views1 answer
Alphabetical order mysql
SQL
0 vote120 views2 answers
How to get json data mysql
SQL
2 votes132 views1 answer
Sqlite indexes
SQL
0 vote135 views2 answers
How to generate a unique random number in mysql
SQL
0 vote130 views1 answer
Mysql terminal list table
SQL
4 votes86 views2 answers
Access to dialectresolutioninfo cannot be null when 'hibernate.dialect' not set
SQL
-1 vote81 views1 answer
How to create script to connect to oracle database and run query
SQL
0 vote134 views1 answer
Create table using the clause with as
SQL