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 votes198 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
0 vote153 views1 answer
Mysql_error replacement
SQL
0 vote160 views2 answers
Uncaught Error: Cannot use object of type mysqli_result as array
SQL
22 votes182 views3 answers
Sql cheat sheet
SQL
0 vote149 views1 answer
Case insensitive sql
SQL
1 vote150 views2 answers
String to date postgres
SQL
0 vote140 views1 answer
Prepared statement mysql java delete selected rows
SQL
0 vote156 views1 answer
MySQL FIND_IN_SET()
SQL
0 vote162 views1 answer
Automatically update database last seen datetime in sql
SQL
1 vote153 views3 answers
Connect to mysql c# connection string C#
SQL