CREATE DATABASE auto_transport;
CREATE TABLE cars(
  id INT IDENTITY(1,1) PRIMARY KEY,
  nomi VARCHAR(50),
  yili INT,
  narxi INT,
  kuzov_turi VARCHAR(50),
  rangi VARCHAR(50),
  tavsif VARCHAR(255));
CREATE TABLE Ishchilar(
  id INT IDENTITY(1,1) PRIMARY KEY,
  Ismi VARCHAR(20),
  Familyasi VARCHAR(20),
  lavozimi VARCHAR(50),
  maosh INT,
  contact VARCHAR(255));
CREATE TABLE mijozlar(
  id INT IDENTITY(1,1) PRIMARY KEY,
  Ismi VARCHAR(20),
  Familyasi VARCHAR(20),
  contact VARCHAR(255),
  address VARCHAR(200));
CREATE TABLE ishlab_chiqarish(
  id INT IDENTITY(1,1) PRIMARY KEY,
  car_id INT,
  boshlash_sanasi datetime,
  tugash_sanasi datetime,
  holati VARCHAR(300),
  FOREIGN KEY (car_id) REFERENCES cars(id));
CREATE TABLE buyurtmalar(
  id INT IDENTITY(1,1) PRIMARY KEY,
  mijoz_id INT,
  car_id INT,
  miqdor INT,
  buyurtma_sanasi datetime,
  yetkazish_sanasi datetime,
  holati VARCHAR(300),
  FOREIGN KEY (mijoz_id) REFERENCES mijozlar(id),
  FOREIGN KEY (car_id) REFERENCES cars(id));
CREATE TABLE sotuvlar(
  id INT IDENTITY(1,1) PRIMARY KEY,
  car_id INT,
  buyurtma_id INT,
  umumiy_miqdor INT,
  narxi INT,
  sotuv_sanasi DATETIME,
  FOREIGN KEY (car_id) REFERENCES cars(id),
  FOREIGN KEY (buyurtma_id) REFERENCES buyurtmalar(id));

INSERT INTO cars (nomi, yili, narxi, kuzov_turi, rangi, tavsif)
VALUES
('Chevrolet Spark', 2020, 9000, 'Hatchback', 'Qora', 'Kichik va tejamkor shahar avtomobili.'),
('Hyundai Sonata', 2019, 20000, 'Sedan', 'Oq', 'Oila uchun qulay sedan.'),
('Toyota Camry', 2018, 22000, 'Sedan', 'Kumush', 'Ishonchli va samarali.'),
('BMW X5', 2021, 50000, 'SUV', 'Qora', 'Luks va kuchli.'),
('Mercedes-Benz C-Class', 2020, 40000, 'Sedan', 'Kok', 'Zamonaviy va qulay.'),
('Audi Q7', 2019, 55000, 'SUV', 'Oq', 'Oilaviy yol tanlamas.'),
('Ford Mustang', 2021, 35000, 'Coupe', 'Qizil', 'Sport korinish va kuchli dvigatel.'),
('Lexus RX', 2020, 45000, 'SUV', 'Kumush', 'Yuqori darajadagi qulaylik.'),
('Honda Civic', 2018, 18000, 'Sedan', 'Kok', 'Ishonchli va samarali.'),
('Nissan Altima', 2019, 19000, 'Sedan', 'Oq', 'Qulay va tejamkor.'),
('Mazda CX-5', 2021, 32000, 'SUV', 'Qizil', 'Sport va uslubiy yoltanlamas.'),
('Tesla Model 3', 2020, 38000, 'Sedan', 'Oq', 'Elektr va zamonaviy.'),
('Volvo XC90', 2018, 47000, 'SUV', 'Qora', 'Xavfsiz va qulay oilaviy avtomobil.'),
('Chevrolet Malibu', 2019, 23000, 'Sedan', 'Oq', 'Yuqori darajada jihozlangan sedan.'),
('Kia Soul', 2021, 20000, 'Hatchback', 'Yashil', 'Yoshlar uchun qulay shahar avtomobili.'),
('Jeep Wrangler', 2020, 40000, 'SUV', 'Qora', 'Sarguzashtlarga mos yol tanlamas.'),
('Volkswagen Golf', 2018, 21000, 'Hatchback', 'Kok', 'Ishonchli va tejamkor.'),
('Subaru Outback', 2019, 30000, 'SUV', 'Kumush', 'Oilaviy va sarguzasht avtomobili.'),
('Porsche Cayenne', 2021, 70000, 'SUV', 'Qizil', 'Luks va kuchli yoltanlamas.'),
('Ferrari Roma', 2020, 200000, 'Coupe', 'Qizil', 'Eng yuqori darajadagi sport avtomobil.');