[![I have the input table like this](https://i.stack.imgur.com/BfcMi.jpg)](https://i.stack.imgur.com/BfcMi.jpg)

Above is the input table.
I am trying to bring all the childsku products in a single row with its count and its associated parent sku.But it is not working as expected

```
         select [Parent SKU (PartNo) ],count([Child SKU]),[Child SKU] 
from tbl_name
       group by [Parent SKU (PartNo) ],[Child SKU]

```

Now I want the desired output to be like this:

[![Desired Output ](https://i.stack.imgur.com/p6mDC.jpg)](https://i.stack.imgur.com/p6mDC.jpg)