I am looking for many hours the solution of a request aggregates.
I have this data : http://pastebin.com/ZUWSDkEX
I want to find the number of person have the consent id 374 and 375 active (status = 1) but dont have the validate id 800 active (status = 1).
I have this query :
But she select and exclude all consent with filter on status.
How i can count only the person have a list of consent id active, and not the other list (active) ?
Thank for you help.