select left(B_num,3) as JD,
       count(B_Num) as BatchCount,
       sum(B_count) as DocCount
from   Batches where report_import_dt = '2005-11-10'
and    b_status in ('RD', 'RO')
group by left(b_num,3)