How to do PIVOT in netezza SQL

If you have table like below

GROUP_NAME  GROUP_ID    PASS_FAIL   COUNT

GROUP1        5            FAIL     382

GROUP1        5            PASS     339 and you want the result to be like GROUP_NAME GROUP_ID PASS FAIL GROUP1 4 339 382

ELECT 
    GROUP_NAME,
    GROUP_ID,
    SUM(CASE WHEN PASS_FAIL = 'PASS' THEN 1 ELSE 0 END) as PASS,
    SUM(CASE WHEN PASS_FAIL = 'FAIL' THEN 1 ELSE 0 END) as FAIL
FROM 
    log a
    join group b 
    on a.group_id=b.group_id
GROUP BY 
    b.group_name,
    a.group_id