Help write an sql

Assume that the table structure is as follows

Id name type name related content

1 A from b hi.

2 A to b hello

Structured query language

select name，count(*)from table where name relate = ' B ' group by name with count(*)& lt； 10