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

3 votes302 views6 answers
Sql unique select
SQL
0 vote162 views1 answer
Drop view in mysql
SQL
1 vote173 views1 answer
Import mysql dump database command line linux
SQL
0 vote179 views1 answer
Check if mysql db is used
SQL
17 votes149 views4 answers
Show tables sql server
SQL
5 votes145 views1 answer
Postgres integer to serial
SQL
0 vote171 views1 answer
Play framework connection via windows sql server
SQL
0 vote176 views1 answer
Sql server python connection
SQL
0 vote170 views1 answer
Postgres reorder columns
SQL
4 votes156 views1 answer
Wilayah indonesia database
SQL