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

5 votes195 views1 answer
JBDC
SQL
0 vote191 views1 answer
Mysql begin statement
SQL
0 vote191 views1 answer
Mysql command prompt date insert format
SQL
0 vote152 views1 answer
Copy table dbeaver
SQL
1 vote199 views1 answer
Postgres check for foreign key
SQL
0 vote221 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
8 votes198 views1 answer
Script to add datafile to tablespace
SQL
11 votes203 views1 answer
Sql insert multiple rows from select
SQL
6 votes187 views3 answers
Mysql server is not starting xampp
SQL
3 votes183 views3 answers
How to set up an auto incrementing id db browser
SQL