sql 查询表中重复数小于3的数据

SELECT point_id,base_id,count(1) as num FROM `point` where base_id IN (SELECT base_id FROM `base`) GROUP BY base_id having count(1)<3;