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 vote302 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
0 vote290 views1 answer
Select from 3 tables one is empty
SQL
0 vote307 views1 answer
Mysql update table from select on another table
SQL
0 vote307 views1 answer
Mysql select field if condition
SQL
0 vote310 views1 answer
Where field is null sql knex
SQL
1 vote293 views4 answers
Between vs in sql
SQL
0 vote305 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
2 votes332 views1 answer
Oracle block
SQL
0 vote345 views1 answer
Bigrock database connection string
SQL
0 vote311 views1 answer
Setval in postgres
SQL