쿼리가 잘 안나와서 질문 좀 드리려고 합니다.

값                      A1                      B1                 -n개

                     A       B                A      B             -n개

0.5              3        4

0.6              5        6

0.7              7       8

0.8              9      10

1.0             11    12

화면에 값을 이런식으로  뿌려야 합니다.

DB에는 아래와 같이 들어간다면 어떻게 쿼리를 짜는게 좋을까요?

피벗함수도 이용해봤는데 잘 안되네요.

값             건수         상위항목           항위항목

0.5            3                  A1                       A

0.6            5                  A1                       A

0.7           7                   A1                        A

0.8           9                  A1                         A

1.0           11                A1                        A

0.5            4                 A1                       B

0.6            6                  A1                       B

0.7           8                  A1                        B

0.8           10                 A1                         B

1.0           12                A1                        B