CODEWITHSUNDEEP
sql
Zannie155
Zannie155

Reputation: 49

Count of person more and equal to 3

Good day

here is the task i have been given: Please could you let me have a report of the Thebemed and Hosmed patients that have been admitted more than 3 x over the past 6 months

And here is the coding i have : *

How can i narrow the members down to => 3

Upvotes: 1

Views: 77

Answers (1)

John Woo
John Woo

Reputation: 263683

add HAVING clause

SELECT...
FROM...
WHERE..
GROUP BY...
HAVING COUNT(*) >= 3

Upvotes: 2

Related Questions