统计数据表中某个字段的值大于2条的数据

select id,member_id,type from visits where type = 1 group by member_id  having count(*) >2;