Questions about SELECT COUNT (*)

Questions about SELECT COUNT (*)!
For example, table structure and data are as follows:

ID typeid Name

1 2 A

2 2 b

3 3 C

4 3 D


I want to implement select COUNT (*) as nums ... where typeid=2 and the name of each record, that is, all the records appear, in the following form:

Nums Name
2 A
2 b


How do I write SQL? mysql5.0 or later

------Solution--------------------
You can still do that.


Select (select COUNT (*) as nums from Test.aa where bbb=2), name from Test.aa
Can pour my system to execute a =_=.

