Guruh Baxtiyorov Quvonchbek Yoqilgi quyish stantsiyasi

951_21-guruh
Baxtiyorov Quvonchbek
Yoqilgi quyish stantsiyasi
create database Yoqilgi_quyish_stantsiyalari
use Yoqilgi_quyish_stantsiyalari
go
create table Xodimlar(Xodimlar_id int, F_I_Sh varchar(100), Tel_raqami int)
insert into Xodimlar values (123,'Nazarov Ali Sadullaevich', 994569815),
(110,'Umarov Sanjar Otabekovich', 943692737),
(101,'Axrorov Bekzod Karimovich', 904532353),
(130,'Otaxonov Suxrob Boburovich', 993224536),
(121,'Yuldoshiv Alisher Murodvich', 919664533),
(119,'Romanov Muxammad Umirbekovich', 937891425),
(122,'Roziboyev Erkin Allaberganovich', 901596548),
(133,'Qurbonov Bobur Ixtiyorovich', 946581235),
(134,'Rajabov Sardor Sadullaevich', 934587636)
select * from Xodimlar

create table Maxsulot (Maxsulot_id int, Keltirilgan_sanasi varchar(30), Maxsulot_miqdori varchar(30))

insert into Maxsulot values(11, '03.02.2022', '18.6 Tonna'),
(12, '07.06.2021', '16 Tonna'),
(13, '30.01.2021', '15.3 Tonna'),
(14, '21.10.2020', '12.4 Tonna'),
(15, '03.12.2020', '6.9 Tonna'),
(16, '17.09.2018', '9 Tonna')
select * from Maxsulot

create table Lavozim (Lavozim_id int, xodimlar_lavozimi varchar(100), Ish_vaqti varchar(100))

insert into Lavozim values (57, 'Bugalter', '8 soat'),
(58, 'Qoriqchi', '24 soat'),
(59, 'Kassir', '24soat'),
(60, 'Ish yurituvchi', '24soat'),
(61, 'Omborchi', '8soat'),
(62, 'Sfat tekshiruvchi', '8soat'),
(63, 'Komputer boyicha texnik', '8soat'),
(64, 'Gaz quyuvchi', '24soat'),
(65, 'Gaz quyuvchi', '24soat')
select * from Lavozim

create table Maxsulot_nomi_va_narxi (Maxsulot_narxi_va_nomi_id int, Maxsulot_nomi varchar(100), Maxsulot_narxi varchar(100))

insert into Maxsulot_nomi_va_narxi values (20, 'Metan', '2500 som'),
(21, 'Propon', '4800 som'),
(22, 'Ai-80', '5700 som'),
(23, 'Ai-85', '6700 som'),
(24, 'Ai-91', '10600 som'),
(25, 'Ai-95', '14300 som')
select * from Maxsulot_nomi_va_narxi
select * from Xodimlar
select * from Maxsulot
select * from Lavozim