How can I make a group amount/ total amount recordset ?

[chu2654]

select id, sum(amount) , percentage(groupsum/total) from XXXX group by id