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 vote174 views1 answer
SQL get max per id
SQL
0 vote143 views1 answer
Postgresql comandos basicos
SQL
0 vote217 views1 answer
Mysql disable triggers
SQL
0 vote187 views1 answer
Mysql faster delete
SQL
9 votes134 views2 answers
Default number in sql
SQL
7 votes145 views2 answers
Get database size mysql
SQL
0 vote138 views1 answer
Groupby error in mysql
SQL
8 votes165 views1 answer
Alter tablespace add datafile autoextend
SQL
0 vote139 views1 answer
Sql server bool select
SQL
17 votes135 views4 answers
Show tables sql server
SQL