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 vote199 views1 answer
Sql how to get courses that i have made prerequisites
SQL
12 votes253 views10 answers
Google
SQL
0 vote200 views1 answer
Sql search all columns of database oracle sql
SQL
0 vote210 views1 answer
Mariadb create index if not exists
SQL
0 vote213 views1 answer
Connect to ssms with python
SQL
1 vote276 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
1 vote222 views1 answer
Add sequence postgres
SQL
0 vote199 views2 answers
Temp tables in sql server
SQL
0 vote186 views2 answers
Mysql two column combination unique
SQL
3 votes204 views2 answers
Mysql config user password
SQL