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

6 votes208 views4 answers
Remove spaces sql server
SQL
0 vote206 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
0 vote196 views1 answer
Change date format in oracle query
SQL
2 votes195 views1 answer
Oracle generated column
SQL
0 vote219 views1 answer
To Create directory
SQL
0 vote202 views1 answer
Failed to connect to localhost:1433 - self signed certificate
SQL
9 votes225 views3 answers
Sequence postgresql
SQL
2 votes195 views1 answer
Set column to not null mysql
SQL
14 votes196 views2 answers
Oracle add column with default value
SQL
6 votes199 views2 answers
Postgresql restore from dump
SQL