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 vote110 views1 answer
Oracle merge insert if not exists
SQL
24 votes116 views4 answers
Postgres remove database
SQL
34 votes149 views6 answers
Alter table add foreign key mysql
SQL
0 vote133 views1 answer
Mysql join only one column
SQL
1 vote119 views1 answer
ORACLE RIGHT TWO DIGITS
SQL
0 vote118 views1 answer
Setval postgres example table id
SQL
0 vote112 views1 answer
Mysql query to check record exists in database table or not
SQL
-1 vote110 views1 answer
Pl/sql how to delete a trigger
SQL
1 vote134 views1 answer
Show databases mysql docker
SQL
0 vote108 views1 answer
Change data type in mysql
SQL