如何写这个sql

Question

一张表，有id、name、no三个字段，查询一个no对应三个以上name的记录。这个sql应该如何写？

Answer 1

select *, count(*) as num
from table
group by no
having num > 3

应该是这样吧

Answer 2

select no from table group by no having count(*)>3;