I need to know how to query a database and ask how many rows have the same record in a column.

For example, I would like to check how many people signed up with a person, so I have the column, referred. Since many people will have the same input on that, how do I check the total number of people with the same input?