would it possible use Dense_rank with Group by together?

 
 
after join 2 tables I got result like this
 
CNO          ABP          BGP           CGP
A111         12             2             2
A121         10             3             8
B111         11             5             14
B121           5  ...