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

6 votes201 views4 answers
Mysql get random row
SQL
3 votes173 views1 answer
Laravel paginate raw sql
SQL
1 vote172 views1 answer
Convert epoch to date in sql server
SQL
2 votes158 views1 answer
Ssh mysql port forwarding
SQL
6 votes177 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
8 votes169 views1 answer
Oracle create datafile
SQL
0 vote176 views2 answers
Replace null with 0 in sql
SQL
0 vote171 views1 answer
Ms sql filter all sympbol
SQL
3 votes163 views1 answer
Créer une table sql
SQL
0 vote168 views1 answer
How to install postgresql on wsl
SQL