i want output in sql :  AWBNO	             STATUS

 123	            DELIVERED

 125	            DELIVERED

 124	               RTO

 126	               RTO

 127	               NDR

 128	               NDR

 131	            DELIVERED

 132	            DELIVERED

 133	               NDR

 134	            DELIVERED


I want output in this way:-

TOTAL   	DELIVERED	  RTO	  NDR

10	            5	       2	   3

