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

2 votes266 views1 answer
Oracle list grants on procedure
SQL
5 votes283 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL
0 vote282 views1 answer
Sql alter table add column if exists
SQL
1 vote289 views1 answer
Mysql size int
SQL
1 vote290 views1 answer
Oracle nvl2
SQL
1 vote266 views1 answer
Mysql show table character set
SQL
0 vote273 views1 answer
Show size of all tables postgres
SQL
0 vote268 views1 answer
How should I pass a table name into a stored proc?
SQL
7 votes280 views3 answers
Python and mysql connectivity
SQL
4 votes269 views2 answers
Could not find driver (SQL: select * from information_schema.tables where table_schema = pics and table_name = migrations and table_type = 'BASE TABLE')
SQL