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

1 vote289 views1 answer
Foreign key in oracle sql developer
SQL
0 vote321 views1 answer
Equi joins in oracle
SQL
2 votes333 views1 answer
Column names in oracle sql
SQL
1 vote304 views1 answer
Mysql collation
SQL
0 vote364 views2 answers
Impala rename column name
SQL
8 votes332 views1 answer
How to remove tables from postgresql
SQL
0 vote340 views2 answers
Add colum in sql
SQL
0 vote313 views1 answer
Add column not null with default value postgres
SQL
0 vote309 views1 answer
How to populate a table in MySQL from and existing csv file
SQL
2 votes311 views1 answer
Postgresql add entry to table
SQL