---

CREATE TABLE students (

    id SERIAL PRIMARY KEY,

    name VARCHAR(15) NOT NULL,

    age INT,

    grade FLOAT,

    phone VARCHAR(11)

);

INSERT INTO students (name, age, grade, phone)

VALUES

('Leha', 19, 4.5, '8984456123'),

('Dani', 27, 3.8, '89111111111'),

('Ivan', 14, 4.2, '89777777777'),

('Gleb', 22, 4.7, '89333333331'),

('Roma', 24, 3.9, '89993334455');

SELECT * FROM students;


CREATE TABLE cars (

    id SERIAL PRIMARY KEY,

    name VARCHAR(15) NOT NULL,

    year INT,

    price FLOAT,

    color VARCHAR(15)

);

INSERT INTO cars (name, year, price, color)

VALUES

('BMW', 2020, 25000, 'Black'),

('Toyota', 2019, 18000, 'White'),

('Audi', 2022, 30000, 'Red'),

('Honda', 2018, 15000, 'Blue'),

('Kia', 2021, 20000, 'Grey');

SELECT * FROM cars;