SELECT GREATEST(
	 ROUND(SELECT SUM(qty) FROM pac.historyreportmonthlybyskuval as hv WHERE hv.id = h.id),
	 ROUND(SELECT SUM(qty) FROM pac.historyreportmonthlybyskuval as hv WHERE hv.id = h.id and mth >= ? and mth <= 11)
	) QTY,
	b.p_dlrnet, b.p_dlrsplrcode   
  FROM pac.historyreportmonthlybysku h -- at least use meaningfull letters!
  JOIN stsc.sku ON sku.loc = h.loc and sku.ITEM = h.dmdunit
 WHERE a.loc     = ?
   AND a.dmdunit = ?
 GROUP BY a.loc, a.dmdunit, b.p_dlrnet, b.p_dlrsplrcode