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 vote212 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
0 vote182 views1 answer
Create duplicate table in postgresql
SQL
2 votes221 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
0 vote209 views1 answer
Oracle select invalid views
SQL
27 votes232 views5 answers
Mysql set password for user
SQL
2 votes257 views1 answer
Oracle find constraints referencing a table
SQL
12 votes229 views6 answers
How to install sqlite3 in python
SQL
9 votes219 views2 answers
Sql limit to 5 results
SQL
0 vote211 views1 answer
Mysql create table like
SQL
1 vote234 views1 answer
Postgresql export output table as a csv
SQL