SELECT mit ORDER BY (zuerst) und GROUP BY (zuletzt)

[Ilja]

yo,

SELECT type, MAX(created_at) Maxwert
FROM x
GROUP BY type
ORDER BY 2, 1
;

Ilja