SQL querry to extract the alert counter of a group host

[Ivanova]

Hello,

I want to extract with a SQL querry the alert counter for a group host.
I've seen topics who where close to my goal (1st & 2nd). But I can not find the link between the table of the host and the alert counter after a few hours of search in the Zabbix DB and on this site.

Do you have an idea of where should I look ? Or some information I can have forgot ?

FI : I'm on the last realese of zbx (5.2.6)

Thanks in advance.