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

11 votes249 views1 answer
Reset identity sql server
SQL
0 vote280 views1 answer
Create bdd mysql
SQL
1 vote280 views1 answer
SQLite order random
SQL
5 votes291 views1 answer
Sysdate in oracle sql
SQL
1 vote269 views1 answer
Oracle sql assign unique number to each grouping
SQL
1 vote337 views1 answer
Mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.
SQL
2 votes283 views1 answer
Query any digits record
SQL
3 votes275 views3 answers
Create table in microsoft sql server
SQL
1 vote283 views1 answer
Convert varchar to int in sqlite
SQL
0 vote264 views1 answer
Like and not like together in sql
SQL