Select group by?

[optime]

select * from
(select nome, auto, 0 as moto
union all
select nome, 0 as auto, moto)
order by nome