Asosiy matnga o'tish
sqlmaster.uzsqlmaster.uz

41. Mahsulot narx darajasini aniqlash

O'rtacha
JOIN'larUzum

Har bir mahsulotga narxi qaysi darajaga tushishini aniqlang.

Daraja price_tiers jadvalida oraliq bilan berilgan: min_price dan max_price gacha

(ikkala chegara ham kiradi).

Ustunlar: name, price, tier_name. Saralash: price o'sish.

products: id, name, price NUMERIC(12,2)

price_tiers: tier_name VARCHAR, min_price NUMERIC, max_price NUMERIC

Jadval: products

UstunTuri
idINT PK
nameVARCHAR(80)
priceNUMERIC(12,2)

Jadval: price_tiers

UstunTuri
tier_nameVARCHAR(20) PK
min_priceNUMERIC(12,2)
max_priceNUMERIC(12,2)

Namuna ma'lumotlar

sample-basic
products
idINTnameVARCHAR(80)priceNUMERIC(12,2)
1Aziz450000
2Bek12000000
3Dilnoza1000000
4Kamola5000000
price_tiers
tier_nameVARCHAR(20)min_priceNUMERIC(12,2)max_priceNUMERIC(12,2)
Arzon0999999.99
O'rta10000005000000
Qimmat5000000.0199999999.99
Kutilgan natija
namepricetier_name
Aziz450000Arzon
Dilnoza1000000O'rta
Kamola5000000O'rta
Bek12000000Qimmat
sample-single
products
idINTnameVARCHAR(80)priceNUMERIC(12,2)
1Aziz2100000
price_tiers
tier_nameVARCHAR(20)min_priceNUMERIC(12,2)max_priceNUMERIC(12,2)
Arzon0999999.99
O'rta10000005000000
Qimmat5000000.0199999999.99
Kutilgan natija
namepricetier_name
Aziz2100000O'rta
sample-boundaries
products
idINTnameVARCHAR(80)priceNUMERIC(12,2)
1Aziz999999.99
2Bek1000000
3Dilnoza5000000
4Kamola5000000.01
price_tiers
tier_nameVARCHAR(20)min_priceNUMERIC(12,2)max_priceNUMERIC(12,2)
Arzon0999999.99
O'rta10000005000000
Qimmat5000000.0199999999.99
Kutilgan natija
namepricetier_name
Aziz999999.99Arzon
Bek1000000O'rta
Dilnoza5000000O'rta
Kamola5000000.01Qimmat

O'xshash masalalar

So'rovni ishga tushirish uchun hisobingizga kiring.
Konsol

Natijani ko'rish uchun so'rovni ishga tushiring.