mysql中按百分比排序- 100%已移至末尾

CREATE TABLE sales (
    id INT PRIMARY KEY,
    product VARCHAR(50),
    percentage DECIMAL(5,2)
);

INSERT INTO sales (id, product, percentage) VALUES
(1, 'Product A', 50.00),
(2, 'Product B', 75.00),
(3, 'Product C', 100.00),
(4, 'Product D', 25.00),
(5, 'Product E', 100.00);

SELECT
    id,
    product,
    percentage
FROM
    sales
ORDER BY
    CASE
        WHEN percentage = 100 THEN 1
        ELSE 0
    END,
    percentage;

 id | product  | percentage
----+----------+------------
  4 | Product D|       25.00
  1 | Product A|       50.00
  2 | Product B|       75.00
  3 | Product C|      100.00
  5 | Product E|      100.00