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 vote112 views1 answer
Sql select lowest value row
SQL
0 vote137 views1 answer
Sql get latest of 2 datetimes
SQL
0 vote116 views1 answer
Psql list view rules
SQL
0 vote129 views1 answer
Shortcut run sql pgadmin
SQL
4 votes138 views4 answers
Mysql get date from datetime
SQL
0 vote115 views1 answer
Pgadmin save data greyed out
SQL
0 vote129 views1 answer
Select * from mysql.proc
SQL
2 votes118 views2 answers
Postgres drop column if exists
SQL
0 vote114 views1 answer
Oracle create job if not exists
SQL
12 votes120 views4 answers
Psql command not found
SQL