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

1 vote173 views1 answer
Mysql backup skip table
SQL
0 vote166 views1 answer
Sql query contains multiple ids
SQL
0 vote154 views1 answer
Minecraft duping allowed servers
SQL
0 vote214 views1 answer
Oracle running queries
SQL
7 votes141 views1 answer
Mysql load data infile csv
SQL
16 votes183 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
0 vote211 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
4 votes195 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
8 votes183 views1 answer
Ltrim sql
SQL
-2 votes224 views1 answer
Trunc in sql
SQL