INSERT INTO ishlab_chiqarish (car_id, boshlash_sanasi, tugash_sanasi, holati)
VALUES
(1, '2023-01-01', '2023-02-01', 'bajarildi'),
(2, '2023-01-15', '2024-03-01', 'kutilmoqda'),
(3, '2023-02-01', '2024-04-01', 'buyurtma berildi'),
(4, '2023-03-01', '2023-05-01', 'bajarildi'),
(5, '2023-04-01', '2024-06-01', 'kutilmoqda'),
(6, '2023-05-01', '2024-07-01', 'buyurtma berildi'),
(7, '2023-06-01', '2023-08-01', 'bajarildi'),
(8, '2023-07-01', '2024-09-01', 'kutilmoqda'),
(9, '2023-08-01', '2024-10-01', 'buyurtma berildi'),
(10, '2023-09-01', '2023-11-01', 'bajarildi'),
(11, '2023-10-01', '2024-12-01', 'kutilmoqda'),
(12, '2023-11-01', '2025-01-01', 'buyurtma berildi'),
(13, '2023-12-01', '2024-02-01', 'bajarildi'),
(14, '2024-01-01', '2024-03-01', 'kutilmoqda'),
(15, '2024-02-01', '2025-04-01', 'buyurtma berildi'),
(16, '2024-03-01', '2024-05-01', 'bajarildi'),
(17, '2024-04-01', '2025-06-01', 'kutilmoqda'),
(18, '2024-05-01', '2025-07-01', 'buyurtma berildi'),
(19, '2024-06-01', '2024-08-01', 'bajarildi'),
(20, '2024-07-01', '2025-09-01', 'kutilmoqda');

INSERT INTO buyurtmalar (mijoz_id, car_id, miqdor, buyurtma_sanasi, yetkazish_sanasi, holati)
VALUES
(1, 1, 1, '2023-01-01', '2023-01-10', 'tayyor'),
(2, 2, 2, '2023-01-15', '2023-01-25', 'tayyor'),
(3, 3, 1, '2023-02-01', '2023-02-10', 'kutilmoqda'),
(4, 4, 2, '2023-03-01', '2023-03-10', 'tayyor'),
(5, 5, 3, '2023-04-01', '2023-04-10', 'kutilmoqda'),
(6, 6, 1, '2023-05-01', '2023-05-10', 'tayyor'),
(7, 7, 2, '2023-06-01', '2023-06-10', 'kutilmoqda'),
(8, 8, 3, '2023-07-01', '2023-07-10', 'tayyor'),
(9, 9, 1, '2023-08-01', '2023-08-10', 'kutilmoqda'),
(10, 10, 2, '2023-09-01', '2023-09-10', 'tayyor'),
(11, 11, 3, '2023-10-01', '2023-10-10', 'kutilmoqda'),
(12, 12, 1, '2023-11-01', '2023-11-10', 'tayyor'),
(13, 13, 2, '2023-12-01', '2023-12-10', 'kutilmoqda'),
(14, 14, 3, '2024-01-01', '2024-01-10', 'tayyor'),
(15, 15, 1, '2024-02-01', '2024-02-10', 'kutilmoqda'),
(16, 16, 2, '2024-03-01', '2024-03-10', 'tayyor'),
(17, 17, 3, '2024-04-01', '2024-04-10', 'kutilmoqda'),
(18, 18, 1, '2024-05-01', '2024-05-10', 'tayyor'),
(19, 19, 2, '2024-06-01', '2024-06-10', 'kutilmoqda'),
(20, 20, 3, '2024-07-01', '2024-07-10', 'tayyor');


INSERT INTO sotuvlar (car_id, buyurtma_id, umumiy_miqdor, narxi, sotuv_sanasi)
VALUES
(1, 1, 1, 20000, '2023-01-11'),
(2, 2, 2, 25000, '2023-01-26'),
(3, 3, 1, 30000, '2023-02-11'),
(4, 4, 2, 35000, '2023-03-11'),
(5, 5, 3, 40000, '2023-04-11'),
(6, 6, 1, 45000, '2023-05-11'),
(7, 7, 2, 50000, '2023-06-11'),
(8, 8, 3, 55000, '2023-07-11'),
(9, 9, 1, 60000, '2023-08-11'),
(10, 10, 2, 65000, '2023-09-11'),
(11, 11, 3, 70000, '2023-10-11'),
(12, 12, 1, 75000, '2023-11-11'),
(13, 13, 2, 80000, '2023-12-11'),
(14, 14, 3, 85000, '2024-01-11'),
(15, 15, 1, 90000, '2024-02-11'),
(16, 16, 2, 95000, '2024-03-11'),
(17, 17, 3, 100000, '2024-04-11'),
(18, 18, 1, 105000, '2024-05-11'),
(19, 19, 2, 110000, '2024-06-11'),
(20, 20, 3, 115000, '2024-07-11');

UPDATE cars
SET nomi = 'Malibu2', narxi = 25000
WHERE id = 1;
UPDATE cars
SET nomi = 'Nexia 2', narxi = 7000
WHERE id = 2;
UPDATE Ishchilar
SET Ismi = 'Sardor', maosh = 5000
WHERE id = 1;
UPDATE Ishchilar
SET Ismi = 'Mohira', maosh = 6000
WHERE id = 14;
UPDATE mijozlar
SET Ismi = 'Asadbek', address = 'Sebzor 13'
WHERE id = 10;
UPDATE mijozlar
SET Familyasi = 'Rashidjonov', address = 'Bogishamol 7'
WHERE id = 15;
UPDATE ishlab_chiqarish
SET tugash_sanasi = '2024-12-31'
WHERE id = 1;

SELECT nomi, narxi, buyurtma_sanasi, yetkazish_sanasi 
FROM cars LEFT JOIN buyurtmalar ON cars.id=buyurtmalar.car_id;

SELECT b.id AS buyurtma_id, 
       b.buyurtma_sanasi, 
       b.yetkazish_sanasi, 
       b.holati, 
       b.miqdor, 
       m.Ismi AS mijoz_ismi, 
       m.Familyasi AS mijoz_familyasi, 
       m.contact AS mijoz_contact, 
       m.address AS mijoz_address, 
       c.nomi AS car_nomi, 
       c.yili AS car_yili, 
       c.narxi AS car_narxi, 
       c.kuzov_turi AS car_kuzov_turi, 
       c.rangi AS car_rangi, 
       c.tavsif AS car_tavsif
FROM buyurtmalar b
INNER JOIN mijozlar m ON b.mijoz_id = m.id
INNER JOIN cars c ON b.car_id = c.id;