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

5 votes131 views1 answer
Pl sql asynchronous procedure calls
SQL
0 vote145 views1 answer
Interview experience as a call?
SQL
1 vote163 views1 answer
Postgresql if 0 then 1
SQL
0 vote136 views2 answers
How to save result of sqlite query in a table
SQL
1 vote132 views1 answer
CREATE DATABASE db; SyntaxError: Unexpected identifier
SQL
1 vote148 views1 answer
Get parameter value in mysql trigger
SQL
0 vote143 views2 answers
Enter into postgresql database,create user and grant Access
SQL
25 votes147 views4 answers
Import mysql dump command line
SQL
1 vote137 views2 answers
Oracle list partitioned tables
SQL
0 vote136 views1 answer
Oracle NLS_CHARACTERSET
SQL