[![enter image description here](https://i.stack.imgur.com/vYglt.png)](https://i.stack.imgur.com/vYglt.png)

A table (ex: `A`) has three columns `id, name, amount`. `Amount` has some +ve,-ve and zero values. How to write a query to get the amount in such a way that it gives as a result first +ve then -ve then zeros? PFA for the sample table.

Thanks in advance