How to compose a query in MySQL to sort by value?

Question

PHP

There is a sign:

Tell me, how to make a query so that there would be sorting by price in ascending order, but the elements with qt = 0 should be displayed last?
That is, in the end I want to get the following result:

Answer 1

try

SELECT * FROM TBL_MYTABLE WHERE qt > '0' ORDER BY price
UNION  SELECT * FROM TBL_MYTABLE WHERE qt = '0' ORDER BY price