---

Louis:
SELECT * FROM products WHERE amount < 500;

SELECT * FROM products WHERE name LIKE 'B%';

-- Создание таблицы
CREATE TABLE products (
    id INT PRIMARY KEY,
    name VARCHAR(100),
    price DECIMAL(10, 2),
    amount INT,
    category VARCHAR(50)
);

-- Вставка данных
INSERT INTO products (id, name, price, amount, category) VALUES
(1, 'Apple', 1.00, 320, 'Fruit'),
(2, 'Cool Fig', 2.00, 100, 'Fruit'),
(3, 'Potato', 0.50, 1000, 'Vegetables'),
(4, 'Carrot', 0.75, 750, 'Vegetables'),
(5, 'Beetroot', 0.25, 1500, 'Vegetables');