The below is the data in a table:
For all the Items whose SoldBill start with either 'D' or 'R', I need the countCode: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
I need the Ouput as below:
I wrote a query which gives output asCode:Name Count of Retun A1 2 B2 0 C3 0
Its not giving the Ouput for rows whose count is zero.Code:Name Count of Retun A1 2