SQL & PL/SQL

Hi Gurus,

I have a following requirement, can anyone please help me.

WITH fw AS 
(
SELECT 123 ID, 'CBAND' service_cd, 'abcd' addr_id FROM dual UNION ALL
SELECT 456 ID, 'LTR' service_cd, 'efgh' addr_id FROM dual UNION ALL
SELECT 789 ID, 'LTR' service_cd, 'ijkl' addr_id FROM dual 
)
,fourg AS
(
SELECT 123 ID, '32' total, '30' available FROM dual UNION ALL
SELECT 456 ID, '15' total, '12' available FROM dual UNION ALL
SELECT 789 ID, '55' total, '52' available FROM dual 
) SELECT * FROM fw,fourg
WHERE fw.id = fourg.id

expected output as

  
  ID   addr_id  cband_total cband_available  ltr_total ltr_available
  123   abcd        32        30               0          0
  456   efgh        0         0               15          12
  789   ijkl        0         0               55          52