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

4 votes288 views2 answers
REST API
SQL
0 vote306 views1 answer
Wordpress delete post revisions older than date "sql"
SQL
17 votes351 views4 answers
Show all tables in oracle
SQL
0 vote283 views1 answer
Mysql change timestamp on update
SQL
1 vote288 views1 answer
PL SQL MODIFY COLUMN NME
SQL
0 vote297 views1 answer
Get date ISO in psql
SQL
5 votes304 views3 answers
Show indexes mysql
SQL
-1 vote293 views1 answer
Mysql select count if contains
SQL
14 votes295 views4 answers
Online sql compiler
SQL
0 vote321 views2 answers
Disallowed function mysql to_date()
SQL