Zabbix action "AND" condition not working

[registration_is_lame]

Why does this not work?
I want SQL_Server-Group-A, SQL_Server-Group-B, SQL_Server-Group-C to send alerts through the action. But I don't want SQL_Server-Group-X, SQL_Server-Group-Y, SQL_Server-Group-Z want to send alerts.

Hosts are in both groups (A, B, C and X, Y, Z). But I've filtered some hosts in X, Y, Z which I want to exclude from sending alerts.

This doesn't work. No alerts are sent out (for A, B, C and X, Y, X). Why is it?
Type of Calculation -> AND -> A and B and (C and D and E)

A Problem is not suppressed
B Trigger name contains SQL
C Host group does not equal SQL_Server-Group-X
D Host group does not equal SQL_Server-Group-Y
E Host group does not equal SQL_Server-Group-Z


This works. SQL_Server-Group-A, SQL_Server-Group-B, SQL_Server-Group-C send alerts. But I wonder if SQL_Server-Group (X. Y, Z) will send alerts as well? I did not get a trigger for X, Y, Z yet but A, B, C works.
Type of Calculation -> AND -> A and B and (C or D or E)


A Problem is not suppressed
B Trigger name contains SQL
C Host group does not equal SQL_Server-Group-X
D Host group does not equal SQL_Server-Group-Y
E Host group does not equal SQL_Server-Group-Z


Can someone explain what is happening? I think I'm understanding the Type of calculation wrongly.\

I want to verify this in the forums so I can test out a "Run remote command on zabbix agent".

[registration_is_lame]

Actually it is working as expected. Just that I couldn't clearly understand.