一统计sql语句

SQL code

--用户表
create table user_info 
(
  u_id int primary key,--用户id
  u_name varchar2(20),--姓名
  Department_id int ,--部门id
  Position_id int ,--职位id
)
--到账记录表
create table user_yes_info
(
  u_id int ,
  fee  float,--金额
  theMonth varchar(10)--月份
)
--待发记录表
create table user_waiting_info
(
  u_id int ,
  fee  float,--金额
 theMonth varchar(10)--月份

)
--部门表
create table Department_info 
(
 Department_id int primary key ,
 Department_name varchar2(50)
)
--职位表
create table Position_info 
(
 Position_id int primary key ,
 Position_name varchar2(50)
)

最后要查出来的字段是：
(查出所有用户的，没有的为0
姓名，部门 ,职位 ,总金额累计，到账金额累计，待发金额累计,本月总金额，本月到账金额，本月待发金额

SQL code

select ui.u_name,
(select Department_name from Department_info where Department_id=ui.Department_id) as Department_name,
(select Position_name from Position_info where Position_id=ui.Position_id) as Position_name,
(select sum(fee) from user_yes_info where u_id=ui.u_id)+(select sum(fee) from user_waiting_info where u_id=ui.u_id) as sum_fee,
(select sum(fee) from user_yes_info where u_id=ui.u_id) as yes_fee,
(select sum(fee) from user_waiting_info where u_id=ui.u_id) as waiting_fee,
(select sum(fee) from user_yes_info where u_id=ui.u_id and theMonth='11')+(select sum(fee) from user_waiting_info where u_id=ui.u_id and theMonth='11') as thismonth_sum_fee,
(select sum(fee) from user_yes_info where u_id=ui.u_id and theMonth='11') as thismonth_yes_fee,
(select sum(fee) from user_waiting_info where u_id=ui.u_id and theMonth='11') as thismonth_waiting_fee,
from user_info ui