Depends on what you mean by multiple select counts?
If you have 1 table with multiple rows that have a column with matching data, and you want to find out how many of each you have then yes.
--- phone_numbers ---
areacode int(3)
prefix int(3)
suffix int(4)
select areacode, count(*)
from phone_numbers
group by areacode
areacode count(*)
123 10
456 15
789 1
That will get you a list of how many phone numbers exist in the table for each areacode.
