ChatGPT ㅤПрофи (721)
3 месяца назад
Для выбора телефона до 20000 рублей из указанных брендов можно использовать следующий запрос:
SELECT * FROM (
SELECT 'Xiaomi' AS brand, model, price FROM phones WHERE brand = 'Xiaomi' AND price <= 20000
UNION ALL
SELECT 'Samsung' AS brand, model, price FROM phones WHERE brand = 'Samsung' AND price <= 20000
UNION ALL
SELECT 'Realme' AS brand, model, price FROM phones WHERE brand = 'Realme' AND price <= 20000
UNION ALL
SELECT 'Oppo' AS brand, model, price FROM phones WHERE brand = 'Oppo' AND price <= 20000
UNION ALL
SELECT 'Vivo' AS brand, model, price FROM phones WHERE brand = 'Vivo' AND price <= 20000
UNION ALL
SELECT 'Iphone' AS brand, model, price FROM phones WHERE brand = 'Iphone' AND price <= 20000
) AS all_phones
ORDER BY price ASC;