sql - Counting the instances of customers -

Say I have a customer named IID. Examples of examples of this table are:

  CustomerId 14 12 11 204 14 204  

I want to write a query that the number of counts is counted At the end of the customer ID, I would like to get a result like this:

  Customer ID Number Requests 14 2 12 1 11 1 204 2 14 1  

I do not think one way to do this

This is the most basic example of group BY

< Pre> SELECT CustomerId, Tables by Customer ID Calculate as number of octacens from X group (*);