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 vote148 views1 answer
Copy value from one column to another postgres
SQL
0 vote142 views3 answers
Get free card roblox
SQL
12 votes150 views1 answer
How to change the value of a table in sql
SQL
0 vote145 views1 answer
Azure sql server check foreign key
SQL
1 vote226 views1 answer
Concat first name and last name in mysql
SQL
0 vote167 views1 answer
Get create sql of hibernqte entity
SQL
1 vote217 views1 answer
Sql server delete top 1000
SQL
0 vote158 views1 answer
How to get one year old query from plan cache
SQL
1 vote147 views1 answer
Get table which have specific columns in mysql
SQL
0 vote145 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL