• Let me mention that when I individually execute without the AND part for each , I get the count as 3 and 8 respectively .

    I am expecting the answer to be 3 but the and brings 0