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 vote184 views2 answers
Reseed sql identity
SQL
0 vote162 views1 answer
Mysql auto increment in DD-MM-XXX format
SQL
1 vote190 views1 answer
Mysql workbench in ubuntu 14.04
SQL
0 vote180 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL
0 vote145 views1 answer
Alter session set nls_language french
SQL
5 votes182 views3 answers
Db begintransaction laravel
SQL
16 votes194 views6 answers
Mysql find duplicates in same table
SQL
0 vote164 views1 answer
Check if table exists oracle
SQL
6 votes188 views4 answers
Mysql get random row
SQL
0 vote162 views1 answer
Psql not found windows
SQL