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
count distinct(*) As Freq
group by Freq
but no success. All help is appreciated!