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

9 votes276 views3 answers
Find all tables with column name
SQL
1 vote292 views1 answer
Nvl postgres
SQL
2 votes253 views1 answer
Codeigniter print last sql query
SQL
1 vote273 views3 answers
Mysql parse int
SQL
0 vote287 views1 answer
Distance calculator from lat long sql query
SQL
0 vote274 views1 answer
Sql ssrs
SQL
3 votes251 views1 answer
Oracle revoke
SQL
1 vote276 views3 answers
Rows, INSERT INTO
SQL
0 vote279 views5 answers
How to make trigger in phpmyadmin
SQL
0 vote245 views1 answer
Soql more than today
SQL