How to write such an SQL statement? It's been an afternoon.

How to write such an SQL statement? It took a whole morning! Exist table Anumid & nbsp; nameText & nbsp; GY-001 & nbsp; I am Sun GY-002 & nbsp; I am moon exist table Bnumid & nbsp; & how to write such an SQL statement? It took a whole morning!
Table
Numid nameText
GY-001 I am Sun
GY-002 I'm the Moon
Table B exists
Numid comment
GY-001 sunspots
GY-001 Sun Mian
GY-001 sun particles
GY-002 meteorite
GY-002 prehistoric civilization
The data I want to retrieve:
Numid nameText cout
GY-001 I'm Moon 3
GY-002 I'm Moon 2


------ Solution --------------------
Select a. numid, a. nameText, count (*) as cout form table A, Table B B where a. numid = B. numid group by a. numid
------ Solution --------------------

Can you try this?

SELECT A.numid,A.nameText,COUNT(A.numid) AS cout FROM A ,B WHERE A.numid = B.numid GROUP BY A.numid