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 vote291 views1 answer
Change date format in oracle query
SQL
6 votes258 views4 answers
Eloquent to sql with bindings
SQL
0 vote287 views5 answers
How to make trigger in phpmyadmin
SQL
11 votes280 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
49 votes311 views6 answers
Get duplicate records in sql
SQL
0 vote273 views2 answers
Collation in sql
SQL
8 votes291 views6 answers
Sql insert
SQL
1 vote254 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL
1 vote267 views1 answer
Create new table in SQL from old table with data
SQL
0 vote268 views1 answer
Teller stamp , bmo , PDF
SQL