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 vote308 views1 answer
Oracle synonym procedure dblink
SQL
3 votes313 views2 answers
Brew start mysql
SQL
0 vote328 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
0 vote317 views2 answers
Wordpress change url in database
SQL
0 vote303 views1 answer
Sql query to delete row by id
SQL
14 votes345 views3 answers
How to add default constraint in mysql
SQL
1 vote287 views2 answers
Mysql SELECT
SQL
8 votes349 views4 answers
Postgresql server restart
SQL
9 votes347 views4 answers
Postgresql export database
SQL
0 vote300 views1 answer
Sub blocks in sql
SQL