Create function yoshi(bosh, int, oxiri int) returns int language bbaass as

MUHAMMAD AL-XORAZMIY NOMIDAGI TOSHKENT AXBOROT TEXNOLOGIYALARI UNIVERSITETI SAMARQAND FILIALI

“KOMPYUTER INJINIRINGI” FAKULTETI

“Ma’lumotlar bazasi” fanidan

4 - Labaratoriya ishi

Bajardi: Ochilov Sardor
Tekshirdi: Xolmatov Orzumurod
S a m a r q a n d 2022
1 - qadam:


create function yoshi(bosh, int, oxiri int)
returns int
language bbaass
as
$$
Declare
yoshi integer;
begin
select count(*)
into yoshi
from
aviakassa
where id between bosh and oxiri;
return yoshi;
end;
select *from aviakassa

2. 
   qadam:
   

create index oylik_maoshi
on aviakassa(manzili)

3 - qadam:

drop index oylik_maoshi

4 - qadam:

create view fakultet as
select xodimlar_fish, lavozimi
from aviakassa

5 - qadam:

drop view fakultet