retirado group by