---

SELECT
    marka,
    model,
    cena,
    CASE
        WHEN cena < 1000000 THEN 'Эконом'
        WHEN cena < 3000000 THEN 'Комфорт'
        ELSE 'Бизнес'
    END AS `Категория`
FROM car
ORDER BY cena ASC;