select lo.lab_items_sub_group_code ,ls.lab_items_sub_group_name,count(lo.lab_order_number) as cc from lab_order lo
left outer join lab_head lh on lh.lab_order_number=lo.lab_order_number
left outer join lab_items_sub_group ls on ls.lab_items_sub_group_code=lo.lab_items_sub_group_code
where lh.order_date between "2011-10-01" and "2011-12-31" and lo.lab_order_result <>"" and lo.lab_order_result is not null and lo.lab_items_sub_group_code <>"0"
group by lo.lab_items_sub_group_code