SQL Statement Suggestions

[eluser]Fielder[/eluser]
How do I return the number of times a particular addendum_id occured in the query? For instance, in the above '100' would return a count of 3 and '300' a count of 1.

Do I put a

Code:

COUNT(addendum_id) Count

in my SELECT statement? And this will return the number of each addendum_id in the subquery?