Calculating frequencies of order quantities

[mjboyd10000]

I am querying a table that has a line for each customer purchase incident.
I am trying to calculate the number of customers who have purchased 1X, 2X, etc.

Final output would look like:

Frequency Count of customers
1 5000
2 4000
3 3000

etc.

I've tried:
Select
count distinct(*) As Freq
From
(Select
VisitMaster.ID,
count(*)
From
VisitMaster
Group By
VisitMaster.ID)
group by Freq

but no success. All help is appreciated!

[johnq7]

just dropping by to say hey

[gk53]

it looks like all what you need there

Select ID, count(*) as cnt
	From VisitMaster
	Group By ID
order by ID