Search all users with alerts qty more then 100

users_with_alerts_gt_100.sql

select u.id, u.login, u.name, p.role
from erm_user u, erm_user_profiles p
where id in (select user_id
from erm_alert
where alert_read = 0
having count(*) > 100
group by user_id)
and u.id = p.user_id
order by 2