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 vote255 views1 answer
List in one column mysql
SQL
0 vote232 views1 answer
Mysql add comment to column
SQL
3 votes246 views1 answer
Oracle user privileges
SQL
22 votes239 views4 answers
Mysql date format
SQL
5 votes234 views1 answer
Purge undo tablespace oracle 11g
SQL
61 votes354 views6 answers
Mysql add column
SQL
1 vote234 views1 answer
How to install mysql 8.0 windows service
SQL
0 vote268 views1 answer
Hue hive UploadingTextFiletoHive
SQL
0 vote233 views1 answer
Export partttion and import in oracle
SQL
4 votes241 views1 answer
Oracle select first 10 rows
SQL