oracle订单查询sql一例

select a1.username,nvl(a2.sum1,0) ,nvl(a3.sum2,0) ,nvl(sum1,0)-nvl(sum2,0) as num1 from member a1
left join(
          select b.member_id,nvl(sum(a.sum_money),0) as sum1 from reserve_list a
          inner join reserve b
          on a.reserve_id=b.id
          where substr(create_time,4,2)=11 
          group by b.member_id
      )a2
on a1.id=a2.member_id
left join(
          select b.member_id,sum(a.sum_money) as sum2 from reserve_list a
          inner join reserve b
          on a.reserve_id=b.id
          where substr(create_time,4,2)=12
          group by b.member_id
     )a3
on a1.id=a3.member_id
order by num1 desc