So’rovlar: select, insert into, delete, update, where, like, order by, group by, in, age

121-20-guruh Talabasi Sulonqulova Dilnozaning Dasturiy injenering fanidan 2- amaliy topshirig’i
SO’ROVLAR: SELECT, INSERT INTO, DELETE, UPDATE, WHERE, LIKE, ORDER BY, GROUP BY, IN, AGE

16. 
    Yangi uylar jadvalini yarating (masalan: Dream house) (id, uy nomi, xonadonlari soni, chiqarilgan yili, qavatlar soni, manzili)
    

Bajarilish tartibi:

1. 
   Ustun va jadvalni yaratish uchun kod
   

create table dream_hause(

id serial primary key,
uy_nomi varchar(50) not null,
xonadonlari_soni int not null,
chiqarilgan_yil varchar(20) not null,
qavatlar_soni int not null,
manzil varchar(256) not null,
maydoni varchar(20),
narxi varchar(50) not null
);

2. 
   Jadvalni chiqarish
   

select * from dream_hause

3. 
   Ma’lumot qo’shish
   

insert into dream_hause(uy_nomi,xonadonlari_soni,chiqarilgan_yil,qavatlar_soni,manzil,maydoni,narxi) values
('nest_one',1200,'12-02-2023',180,'toshkent city','50kvm','$90000');

4.Ma’lumotni o’chirish

delete from dream_hause where id=10

5.Ma’lumotni tahrirlash
update dream_hause set uy_nomi='kamsamol' where id=5

6. Order by

select * from dream_hause order by uy_nomi

7. Group by

select uy_nomi from dream_hause group by uy_nomi

8. LIKE
select * from dream_hause where uy_nomi like 'gu%'

9. IN
select * from dream_hause where narxi in ('$90000')

10. BETWEEN
select * from dream_hause where narxi between '$80000' and '$90000'