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 votes122 views4 answers
Show columns from table
SQL
-1 vote164 views2 answers
On update cascade
SQL
12 votes176 views4 answers
Mysql version query
SQL
0 vote216 views1 answer
I wanted to select among the rows the highest value in mysql
SQL
9 votes163 views2 answers
Cmd to rename a collumn name in sql
SQL
0 vote188 views1 answer
Format the money fied with comma in international system using sql
SQL
0 vote178 views1 answer
Exception message: The connection name 'SqlServices' was not found in the applications configuration or the connection string is empty.
SQL
0 vote175 views1 answer
Addition of 2 column value in mysql
SQL
2 votes172 views1 answer
Mysql select random id from table
SQL
0 vote187 views2 answers
Update query with between in mysql
SQL