select name, ip, environment, type, last_update
from test 
where environment = 'PROD'
and last_update in (
   select max(last_update)
   from test
   where environment = 'PROD'
   group by type
)
order by type