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

14 votes206 views3 answers
Trim sql
SQL
0 vote213 views1 answer
Check command
SQL
0 vote204 views1 answer
How to make full text search dynamic in mysql
SQL
1 vote207 views1 answer
Oracle turn off constraint
SQL
24 votes181 views5 answers
Sql reset auto increment
SQL
0 vote237 views3 answers
How to find all role in mysql
SQL
2 votes196 views1 answer
Mysql query unique column
SQL
1 vote202 views1 answer
Get last week data in mysql
SQL
61 votes313 views6 answers
Mysql add column
SQL
2 votes181 views1 answer
Sql select min value from multiple columns
SQL