这种语句怎么写？

Question

SELECT   status, min(doorplate),min((buildId)
FROM Peoples
group by status
ORDER BY status

Answer 1

select a1.status,a2.doorplate,a2.buildid
from   peoples as a1,(select distinct doorplate,buildid from peoples) as a2
where a1.doorplate=a2.doorplate

Answer 2

SELECT  status, max(doorplate),max(buildId)
FROM Peoples
ORDER BY status

Answer 3

select a.* frompeoples a,
( select distinct status from peoples)b
where a.status=b.status
order by status

Answer 4

SELECT status, doorplate,buildId
FROM Peoples
group by status, doorplate,buildId
ORDER BY status