selecting row counts

[gandolf989]

You are asking about and aggregate query:

SELECT patient, COUNT(*)
  FROM appointment
 GROUP BY patient
ORDER BY 1;