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

15 votes290 views4 answers
T-sql drop function if exists
SQL
0 vote314 views1 answer
What is initial catalog in sql connection string
SQL
0 vote292 views2 answers
How to find sql server agent jobs related to a database
SQL
1 vote297 views1 answer
Mysql query where in select
SQL
0 vote268 views1 answer
Sql from null to not null
SQL
0 vote292 views1 answer
Query archive mode
SQL
1 vote249 views1 answer
Restart identity postgresql
SQL
16 votes297 views1 answer
Mssql int max value
SQL
0 vote304 views1 answer
Sort by
SQL
0 vote279 views1 answer
Sql examples from your work
SQL