46. Klinika → tuman → viloyat
O'rtachaHar bir klinika qaysi tuman va qaysi viloyatda joylashganini qaytaring:
clinic, district, region.
Saralash: region, district, clinic — hammasi alifbo.
regions: id, name · districts: id, name, region_id
clinics: id, name, district_id
Jadval: regions
| Ustun | Turi |
|---|---|
| id | INT PK |
| name | VARCHAR(50) |
Jadval: districts
| Ustun | Turi |
|---|---|
| id | INT PK |
| name | VARCHAR(50) |
| region_id | INT |
Jadval: clinics
| Ustun | Turi |
|---|---|
| id | INT PK |
| name | VARCHAR(80) |
| district_id | INT |
Namuna ma'lumotlar
sample
regions
| idINT | nameVARCHAR(50) |
|---|---|
| 1 | Toshkent |
| 2 | Samarqand |
districts
| idINT | nameVARCHAR(50) | region_idINT |
|---|---|---|
| 1 | Chilonzor | 1 |
| 2 | Urgut | 2 |
clinics
| idINT | nameVARCHAR(80) | district_idINT |
|---|---|---|
| 1 | Shifo Plus | 1 |
| 2 | Sog'lom Avlod | 2 |
Kutilgan natija
| clinic | region | district |
|---|---|---|
| Sog'lom Avlod | Samarqand | Urgut |
| Shifo Plus | Toshkent | Chilonzor |
sample-full
regions
| idINT | nameVARCHAR(50) |
|---|---|
| 1 | Toshkent |
| 2 | Samarqand |
| 3 | Buxoro |
| 4 | Farg'ona |
districts
| idINT | nameVARCHAR(50) | region_idINT |
|---|---|---|
| 1 | Chilonzor | 1 |
| 2 | Yunusobod | 1 |
| 3 | Sergeli | 1 |
| 4 | Urgut | 2 |
| 5 | Kattaqo'rg'on | 2 |
| 6 | Kogon | 3 |
| 7 | G'ijduvon | 3 |
| 8 | Quva | 4 |
| 9 | Marg'ilon | 4 |
clinics
| idINT | nameVARCHAR(80) | district_idINT |
|---|---|---|
| 1 | Shifo Plus | 1 |
| 2 | Sog'lom Avlod | 4 |
| 3 | Med Center | 1 |
| 4 | Salomatlik | 2 |
| 5 | Doktor Shifo | 6 |
| 6 | Nur Med | 8 |
| 7 | Hayot Klinika | 3 |
| 8 | Zamon Med | 9 |
| 9 | Oila Shifoxonasi | 5 |
| 10 | Yangi Hayot | 7 |
Kutilgan natija
| clinic | region | district |
|---|---|---|
| Yangi Hayot | Buxoro | G'ijduvon |
| Doktor Shifo | Buxoro | Kogon |
| Zamon Med | Farg'ona | Marg'ilon |
| Nur Med | Farg'ona | Quva |
| Oila Shifoxonasi | Samarqand | Kattaqo'rg'on |
| Sog'lom Avlod | Samarqand | Urgut |
| Med Center | Toshkent | Chilonzor |
| Shifo Plus | Toshkent | Chilonzor |
| Hayot Klinika | Toshkent | Sergeli |
| Salomatlik | Toshkent | Yunusobod |
sample-extra
regions
| idINT | nameVARCHAR(50) |
|---|---|
| 1 | Buxoro |
| 2 | Samarqand |
| 3 | Toshkent |
districts
| idINT | nameVARCHAR(50) | region_idINT |
|---|---|---|
| 1 | Chilonzor | 1 |
clinics
| idINT | nameVARCHAR(80) | district_idINT |
|---|---|---|
| 1 | Sardor Qodirov | 1 |
Kutilgan natija
| clinic | region | district |
|---|---|---|
| Sardor Qodirov | Buxoro | Chilonzor |
O'xshash masalalar
Konsol
Natijani ko'rish uchun so'rovni ishga tushiring.