Count two fields by group by

[D19PAL]

Hi

How do I do this, 

Count if BBB is populated where there is a 1 in AAA per I'd

So I'd 1 = 2 and 2 = 1

Id , AAA, BBB

1,1,B

1,1,B

1,2,B

2,1,B

2,2,B

2,2,B

Thanks

[chaorenzhu]

count({<AAA={'1'}>} BBB)

[D19PAL]

Sorry in script 

[chaorenzhu]

load Id,count(BBB) as BBB_count
resident your_table_name
where AAA=1
group by Id;