SQL help requried

I have a view as follows:

DEPARTMENT_CODE VARCHAR(5)
ITEM_WAREHOUSE VARCHAR(5)
TOTAL_DEMANDS INTEGER
PRICE INTEGER
DEMAND_DATE DATE


This view displays Total Demands requested on specified date (e.g. BETWEEN 1996-01-01 AND 1996-05-01) by Departments, GROUP BY Warehouse Code and Department Code.

Now I want to generate a query that will return me with the

Dept, Demands_Warehouse (A,B,E), Demands_Warehouse (C, D)
01 11 03
02 05 01
03 00 07
04 00 00
………………..

Can any body help me write this query …