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

3 votes102 views1 answer
Mysql load sql from file
SQL
0 vote96 views1 answer
Cast for print sql
SQL
0 vote107 views1 answer
Shortcut run sql pgadmin
SQL
1 vote68 views2 answers
Get date from datetime postgresql
SQL
1 vote100 views1 answer
Oracle avg
SQL
16 votes117 views3 answers
Order by sql query
SQL
0 vote113 views1 answer
Oracle lower in where clause
SQL
0 vote116 views2 answers
How to get max from each department in sql
SQL
1 vote148 views1 answer
Delete mysql ubuntu 20.04
SQL
0 vote587 views1 answer
Sql show table name in result
SQL