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

1 vote127 views1 answer
Show all event schedular on mysql
SQL
0 vote125 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
0 vote126 views1 answer
Oracle INTERVAL DAY to second to number
SQL
1 vote134 views1 answer
Does insert into overwrite sql
SQL
1 vote116 views1 answer
Sql only five first row
SQL
-1 vote128 views1 answer
Get id from just inserted row mysql server python
SQL
0 vote134 views1 answer
Postgresql import data from csv
SQL
0 vote133 views1 answer
Get id if is not equal in certain table
SQL
0 vote118 views1 answer
VSCode SQL Server Connection error
SQL
12 votes140 views5 answers
Sql primary key
SQL