Help with grouping

Copper Contributor
Hi 

I have Table A and I want output like Table B

Let me know if you can have a look, if you could, that would be great.

 

Screenshot -Stackflow.png

 

1 Reply
I can not query images.
Please post table design as DDL, some sample data as DML statement and the expected result.