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 vote129 views1 answer
Declare or use variable in snowflake
SQL
0 vote112 views1 answer
Phpmyadmin mysql conflict
SQL
0 vote93 views1 answer
Postgresql add leading zeros
SQL
4 votes119 views2 answers
Truncate oracle
SQL
0 vote123 views1 answer
Mysql workbench view
SQL
0 vote156 views1 answer
How to pass list as parameter in SQL query
SQL
0 vote118 views1 answer
Create table employees oracle
SQL
13 votes258 views4 answers
Sql joining 3 tables
SQL
0 vote148 views2 answers
How to retrive image from sql to picturebox usinf image location
SQL
0 vote127 views1 answer
Restore backup mysql .gz
SQL