With the following query:

```
SELECT STAT, SHNO, ORDERNO FROM  BLUEWATER ORDER BY SHNO; 

```

I can get the following: 

```
STAT      SHNO     ORDERNO                                                                                                                                     
40      ASN123   40303020                                                                                                                                    
40      ASN123   40303020                                                                                                                                    
30      ASN124   40303021                                                                                                                                    
30      ASN124   40303021                                                                                                                                    
30      ASN125   40303021    

```

I am looking for a query that will eliminate duplicate SHNO rows and then create a fourth column that is a sum of the number of ORDERNO repeats (this total is calculated after having eliminated SHNO duplicates). 

The target database is DB2. I currently don't know what version but will seek to ascertain this although I am assuming not a recent version. 

My goal is a query that produces the following: 

```
STAT      SHNO     ORDERNO  ORDERNOTOTAL                                                                                                                    
40      ASN123   40303020    1                                                                                                                               
30      ASN124   40303021    2                                                                                                                               
30      ASN125   40303021    2     

```

The solution need to avoid use of the PARTITION keyword as this version of DB2 doesn't accept it.