Complete absent

Question

Hi

  I have below data . Since all students are absent in 3B . Result should be 1 . I want thru Linq query.

Group	Student	Present
2A	2	Y
2A	5	Y
3B	2	N
3B	5	N
3B	3	N
4A	2	Y
4A	5	N

Thanks