Subject Re: Query optimalisation
I´m not sure if I understand... but...

you need count how many times it was in (B and C),
how many times it was in B sum C, or ...??

regards