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

10 votes112 views5 answers
Between keyword in sql
SQL
0 vote110 views1 answer
How to get inserted id in sql server
SQL
0 vote110 views1 answer
Flask sqlalchemy decimal
SQL
0 vote120 views1 answer
Npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] install script.
SQL
0 vote116 views1 answer
Sql server python connection
SQL
2 votes97 views1 answer
Oracle create directory
SQL
4 votes101 views1 answer
Search column by name mysql
SQL
10 votes112 views4 answers
SELECT FROM WHERE
SQL
0 vote104 views1 answer
Downgrading sql localdb visual studio
SQL
0 vote108 views1 answer
Cartesian product sql
SQL