19. OLX: narx oralig'idagi e'lonlar
OsonE'lonlar listings jadvalida saqlanadi.
Narxi 5 000 000 dan 15 000 000 gacha (ikkala chegara ham kiradi) bo'lgan
e'lonlarning title, price, city ustunlarini qaytaring.
Natijani narx bo'yicha o'sish tartibida saralang.
Jadval: listings
| Ustun | Turi |
|---|---|
| id | INT PK |
| title | VARCHAR |
| price | NUMERIC(14,2) |
| city | VARCHAR |
Namuna ma'lumotlar
sample-basic
listings
| idINT | titleVARCHAR(100) | priceNUMERIC(14,2) | cityVARCHAR(50) |
|---|---|---|---|
| 1 | iPhone 13 | 12000000 | Toshkent |
| 2 | Divan | 3000000 | Samarqand |
| 3 | Samsung TV | 8000000 | Buxoro |
| 4 | Konditsioner | 18000000 | Andijon |
Kutilgan natija
| city | price | title |
|---|---|---|
| Buxoro | 8000000 | Samsung TV |
| Toshkent | 12000000 | iPhone 13 |
sample-boundary
listings
| idINT | titleVARCHAR(100) | priceNUMERIC(14,2) | cityVARCHAR(50) |
|---|---|---|---|
| 1 | Min | 5000000 | Toshkent |
| 2 | Max | 15000000 | Xiva |
| 3 | Below | 4999999.99 | Nukus |
| 4 | Above | 15000000.01 | Qarshi |
Kutilgan natija
| city | price | title |
|---|---|---|
| Toshkent | 5000000 | Min |
| Xiva | 15000000 | Max |
sample-none
listings
| idINT | titleVARCHAR(100) | priceNUMERIC(14,2) | cityVARCHAR(50) |
|---|---|---|---|
| 1 | Cheap | 100000 | Jizzax |
| 2 | Lux | 90000000 | Navoiy |
O'xshash masalalar
Konsol
Natijani ko'rish uchun so'rovni ishga tushiring.