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

1 vote138 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception
SQL
0 vote208 views1 answer
Mariadb date equals to current_date plus days
SQL
1 vote136 views1 answer
Create email address from first and last name in sql
SQL
0 vote144 views1 answer
Sql select merge multiple values
SQL
2 votes144 views1 answer
Node and mysql like
SQL
0 vote141 views4 answers
Best data type to represent money in mysql
SQL
0 vote135 views1 answer
T-sql email validation
SQL
1 vote146 views1 answer
Round one decimal place mysql
SQL
0 vote135 views1 answer
Mysql select where field like in list
SQL
34 votes164 views6 answers
Install mysql client ubuntu
SQL