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

3 votes117 views2 answers
Mysql add 2 hours
SQL
0 vote134 views1 answer
Mysql 8 geo to json
SQL
1 vote138 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
0 vote134 views1 answer
Mariadb mysql root access denied
SQL
4 votes194 views1 answer
Mysql store ip address
SQL
0 vote144 views2 answers
Unique key
SQL
0 vote128 views1 answer
Exclude last comma separated string mysql
SQL
0 vote132 views3 answers
Between keyword sql
SQL
1 vote137 views2 answers
Postgresql check privileges on schema
SQL
0 vote132 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL