HAVING

SELECT id, name, family, mobile, COUNT(mobile) as tt FROM `user_login` where deleted=0 GROUP BY `mobile` HAVING tt > 1;

SELECT user_id, COUNT(user_id) as tt FROM `tarh` WHERE finished = 1 GROUP BY `user_id` HAVING tt > 1 ORDER BY `tt` DESC