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 vote210 views1 answer
SQL Cut part string
SQL
3 votes192 views1 answer
Oracle list invalid password logon denied
SQL
1 vote189 views3 answers
How to pass password to mysql command line
SQL
3 votes264 views2 answers
Mysql user permission database
SQL
0 vote162 views1 answer
VSCode SQL Server Connection error
SQL
1 vote216 views1 answer
Default
SQL
1 vote216 views1 answer
Create sqlite database in laravel
SQL
1 vote248 views1 answer
Insert column after column mysql
SQL
0 vote234 views1 answer
Sqlalchemy query return only n results
SQL
6 votes296 views1 answer
Sql insert values into table
SQL