I have a table in the following format:

place   stage   type
AFA11    1     TYPE_A                                                            
AFA11    2     TYPE_B                                                           
AFA12    1     TYPE_A                                                            
AFA12    2     TYPE_B   

The query that i'm trying is:

SELECT place,
CASE when type = 'TYPE_A' THEN stage end type_A ,
CASE when type= 'TYPE_B' THEN stage end type_B 
FROM table  WHERE place LIKE '