select max(CASE WHEN city='Banglore' then name end) as Banglore ,max(CASE WHEN city='Mumbai' then name end) as Mumbai ,min(CASE WHEN city='Delhi' then name end) as Delhi ...