Click here to Skip to main content
15,868,142 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
BRNNAME SCORE COUNTS ALL_PERCENTAGE |GRP_PERCENTAGE
--------------------------------------------------------|-----------------
CAPE COAST DELIGHTED 7 29.167000000000 |
CAPE COAST GOOD 1 4.167000000000 |
--------------------------------------------------------|-----------------
HOHOE DELIGHTED 4 16.667000000000 |
HOHOE GOOD 2 8.333000000000 |
HOHOE SATISFACTORY 1 4.167000000000 |
HOHOE UNHAPPY 1 4.167000000000 |
--------------------------------------------------------|------------------
KUMASI BAD 1 4.167000000000 |
KUMASI DELIGHTED 6 25.000000000000 |
KUMASI GOOD 1 4.167000000000 |


SELECT BRNNAME,SCORE,count(BRNNAME) AS COUNTS, ROUND(100.0*COUNT(BRNNAME)/(SELECT count(BRNNAME)  FROM cte3),3)
 as ALL_PERCENTAGE ,
 ROUND(100.0*COUNT(BRNNAME)/(SELECT count(BRNNAME)  FROM cte3),3)
 as GRP_PERCENTAGE 
 FROM  cte3 GROUP BY BRNNAME,SCORE
            ORDER BY BRNNAME,SCORE


Need to compute percentages at the Branch level in addition


BRNNAME SCORE COUNTS ALL_PERCENTAGE |GRP_PERCENTAGE
--------------------------------------------------------|-----------------
CAPE COAST DELIGHTED 7 29.167000000000 | 87.5%
CAPE COAST GOOD 1 4.167000000000 | 12.5%
--------------------------------------------------------|-----------------

Cape Coast has 8 counts (7+1)

Cape Coast DELIGHTED = (7*100)/8= 87.5%
Cape Coast GOOD = (1*100)/8= 12.5%

How do achieve the above.

Thanks

What I have tried:

Select statement under development
Posted
Updated 9-Nov-17 21:25pm

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900