Help in Query

[hiteshkataria]

The below is the data in a table:

Name	Cost	SoldAmt	SoldBill
A1	5	8		22
B2	1		
A1	8	15		21
C3	5	10		20
A1	7	8		R2
A1	8		
A1	5	3		D2
B2	3	2		18
B2	3		
C3	1

For all the Items whose SoldBill start with either 'D' or 'R', I need the count

I need the Ouput as below:

Name	Count of Retun
A1	2
B2	0
C3	0

I wrote a query which gives output as

Name	Count of Retun
A1	2

Its not giving the Ouput for rows whose count is zero.

[PAVB]

Business specs match the results of your -unpublished- query.
Business specs are adamant about the rows that have to be considered - based on value of SoldBill column.