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 vote355 views1 answer
Empty table sqlite
SQL
104 votes575 views2 answers
Like in mysql
SQL
5 votes354 views1 answer
Oracle get nls settings
SQL
0 vote337 views1 answer
How to insert same table data using mysql query
SQL
0 vote341 views1 answer
Import all databases mysql
SQL
2 votes377 views5 answers
Eloquest how to select one specific column in database
SQL
0 vote349 views1 answer
How to convert DateTime to VarChar SQL
SQL
4 votes367 views2 answers
Insert current date in mysql
SQL
0 vote470 views1 answer
How to rename a database in tsql
SQL
0 vote347 views2 answers
How to find max and min salary in sql
SQL