Random andmed

Random andmed-https://www.mockaroo.com/

XAMPP localhost

create table kliendiAuto (
id INT PRIMARY KEY,
first_name VARCHAR(50),
last_name VARCHAR(50),
email VARCHAR(50),
car_make VARCHAR(50),
car_model VARCHAR(50),
car_year INT,
car_price DECIMAL(7,2)
);

insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (1, ‘Becki’, ‘Heffron’, ‘bheffron0@irs.gov’, ‘Dodge’, ‘Challenger’, 2012, 625.83);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (2, ‘Maxim’, ‘Brookzie’, ‘mbrookzie1@illinois.edu’, ‘Cadillac’, ‘Seville’, 1998, 4927.96);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (3, ‘Bail’, ‘Leadston’, ‘bleadston2@gov.uk’, ‘Chevrolet’, ‘Camaro’, 2002, 1459.76);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (4, ‘Owen’, ‘Killelea’, ‘okillelea3@marriott.com’, ‘Nissan’, ‘Stanza’, 1992, 6582.65);

Lisa vähemalt 3 kliendi andmed, millest üks oled sina.

insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (101, ‘Gleb’, ‘Sotsjov’, ‘123@irs.gov’, ‘Dodge’, ‘Challenger’, 2012, 625.83);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (102, ‘Kirill’, ‘Sats’, ‘1234@illinois.edu’, ‘Cadillac’, ‘Seville’, 1998, 4927.96);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (103, ‘bogdan’, ‘sergachev’, ‘1112@gov.uk’, ‘Chevrolet’, ‘Camaro’, 2002, 1459.76);

Muuda enda lisatud automargiks Zaporožets

Muuda kõik Cadillac margid Citroën’iks

Kustuta ära read, mille ID on 5, 10 ja 15

Kuva read, kus on ainult ID, perenimi, automark ja aasta, sorteeri ID järgi kasvavalt:

Kuva 10 rida autosid, kus kliendi perenimi hakkab sama algustähega, mis sul, sorteeri autod aasta järgi kahanevalt peremimi algab ‘S’

Kuva 2 vabalt valitud automarki sisaldavad read ja ületavad mingit summat

Keskmine autode hind ja summarne autode hind

Oma tabeli lisamine.

create table Valamu (
valamuID INT PRIMARY KEY,
kuupäev DATE,
first_name VARCHAR(50),
hind INT,
kliendiAutoid INT,
FOREIGN KEY (kliendiautoid) REFERENCES kliendiauto(id)
);

MC ACCES

create table kliendiAuto (
id INT PRIMARY KEY,
first_name VARCHAR(50),
last_name VARCHAR(50),
email VARCHAR(50),
car_make VARCHAR(50),
car_model VARCHAR(50),
car_year INT,
car_price Int
);