Kafedra: " Transportda axborot tizimlari va texnologiyalari " 3-laboratoriya ishi

O’ZBEKISTON RESPUBLIKASI OLIY VA O'RTA MAXSUS TA'LIM VAZIRLIGI
TOSHKENT DAVLAT TRANSPORT UNIVERSITETI
Kafedra: " Transportda axborot tizimlari va texnologiyalari "
3-LABORATORIYA ISHI
Fanning nomi: Ma’lumotlar va bilimlar banki

AT-3 guruh	FISH	SANA	IMZO
Bajardi :	Qadamboyev M.I.	28.03.2023
Qabul qildi:	G’afforov N.Y.

Toshkent - 2023 yil
3-LABORATORIYA ISHI
Mavzu: SQL tili yordamida sodda so‘rovlar yaratish.
Ishdan maqsad: SQL tili yordamida avvaldan yaratilgan jadvalga so‘rovlar yaratish hamda natijalar olish.







s elect op_shifokorlar.full_name,city.city from op_shifokorlar,city where op_shifokorlar.birth_city=city.id_c
s elect full_name,birthday from op_shifokorlar where birthday>'01-01-1976'
s elect op_shifokorlar.full_name,op_ishchilar.directions_op from op_shifokorlar,op_ishchilar where op_shifokorlar.directions_op =op_ishchilar .id_op
select * from op_shifokorlar where full_name like 'Ab%'



select op_shifokorlar.full_name,op_shifokorlar.birthday,city.city,op_ishchilar.directions_op from op_shifokorlar,city,op_ishchilar where op_shifokorlar.birth_city=city.id_c and op_shifokorlar.directions_op =op_ishchilar .id_op