请问用SQL如何编制以下报表答:收入金额) as (select '原料仓','01.01','原料1','注塑','PCS',2,100,200 union allselect '原料仓','01.02','原料2','','PCS',3,100,300 union allselect '原料仓','01.03','原料3','喷油','PCS',4,
SQL 统计报表答:create table tab1 (id int, output_style char(1), amount int, output_date date);insert into tab1 values(1,'D',1000,to_date('2009-11-12','yyyy-mm-dd'));insert into tab1 values(2,'C',1000,to_date('2009-11-12','yyyy-mm-dd'));insert into tab1 values(3,'G',1...