How by means of SQL (oracle) to sort records by the status?

Question

Oracle

There is such a table

How to sort this table so that first there are products in the "cancelled" status and then all the rest in any order? It only comes to mind to use union (the first query will select records in the "cancelled" status and the second query will select records without records in the "cancelled" status)
Are there any ways to make custom sorting?

Answer 1

Orakla is not at hand, but the idea, I think, is clear.

SELECT name, status, price, 
   CASE status WHEN 'cancelled' THEN 0
   ELSE 1 END as pos
FROM TABLE
ORDER BY pos;