Sql include rows with 0 values

# By default, INNER JOIN excludes person_id with no appointments (NULL value, COUNT(NULL)
# returns 0). Can learn/practice more at http://sqlzoo.net/wiki/Using_Null
SELECT person.person_id, COUNT(appointment.person_id) AS "number_of_appointments"
FROM person 
  LEFT JOIN appointment ON person.person_id = appointment.person_id
GROUP BY person.person_id;

Source: stackoverflow.com

Similar codes

0 vote189 views1 answer
Bidirectional outer join sql
SQL
1 vote173 views1 answer
Sql server reseed single table
SQL
0 vote187 views1 answer
Array aggre distinct postgres
SQL
13 votes179 views2 answers
Check if value is null mysql
SQL
16 votes251 views6 answers
Mysql find duplicates in same table
SQL
-1 vote183 views1 answer
Mysql order by on condition
SQL
0 vote187 views1 answer
Null column as zero in mysql
SQL
4 votes253 views1 answer
Postgresql list sequences
SQL
4 votes138 views2 answers
Access to dialectresolutioninfo cannot be null when 'hibernate.dialect' not set
SQL
0 vote190 views1 answer
Heidisql check how much space a row
SQL