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 vote341 views2 answers
Full join
SQL
0 vote306 views1 answer
Sql trigger to call stored procedure with parameters
SQL
0 vote298 views1 answer
Mysql replication change database name
SQL
0 vote315 views1 answer
QCompleter con sql
SQL
1 vote302 views1 answer
Tsql create unique index composite
SQL
0 vote296 views1 answer
Hive batch drop table
SQL
0 vote309 views1 answer
Mysql sum with group by
SQL
0 vote325 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
1 vote324 views1 answer
Sqlserver create table from select
SQL
0 vote285 views1 answer
Sqldf change user
SQL