Muhammad al-xorazmiy nomidagi toshkent axborot texnologiyalari universiteti 2 – bosqich dbm002-guruh talabasi Abdimannonov Jahongirning “Ma’lumotlar bazasi” fanidan bajargan 3- mustaqil ishi

Natija:

So`rov: So`rov: select max(id) as ‘eng oxirida turgan yolovchi ‘from maxsulot group by qurilma_id;

So`rov: So`rov: select max(id) as ‘eng oxirida turgan yolovchi ‘from maxsulot group by qurilma_id;

Natija:

So’rov: Select korpus_id as ‘2 ta yoki 2 tadan kop id lari’ , count(status) as ‘biletlar soni’ from ticket group by korpus_id having count(maxsulot_nomi)>=2;

So’rov: Select korpus_id as ‘2 ta yoki 2 tadan kop id lari’ , count(status) as ‘biletlar soni’ from ticket group by korpus_id having count(maxsulot_nomi)>=2;

Natija:

So’rov: Select count(*) as ‘bilrtlar soni’ from qurilma;

So’rov: Select count(*) as ‘bilrtlar soni’ from qurilma;

Natija:

So’rov: Select id, fullname , rand(id) from passenger;

So’rov: Select id, fullname , rand(id) from passenger;

Natija:

Yaxlitliydi

Yaxlitliydi

So`rov: Select id, maxsulot_nomi, round(id/passenger_id, 3) from maxsulot;

Natija:

Select korpus_id, qurilma_id, power(korpus_id, qurilma_id) from maxsulot;

Select korpus_id, qurilma_id, power(korpus_id, qurilma_id) from maxsulot;

Natija:

So`rov:Select passenger _id, sqrt(passenger_id) from maxsulot;

• So`rov:Select passenger _id, sqrt(passenger_id) from maxsulot;
• Natija:

So`rov: Select passenger_id, sin(passeger_id) from maxsulot;

So`rov: Select passenger_id, sin(passeger_id) from maxsulot;

Natija:

So`rov: Select passenjer_id, log(passenger_id) from maxsulot;

So`rov: Select passenjer_id, log(passenger_id) from maxsulot;

Natija:

So`rov: Select *from qurilma where id between 1 and 3;

So`rov: Select *from qurilma where id between 1 and 3;