22. Klinika: familiyasida "ova" bo'lgan shifokorlar
OsonShifokorlar doctors jadvalida.
To'liq ismida ova ketma-ketligi uchraydigan shifokorlarning
full_name, specialty ustunlarini qaytaring.
Qidiruv registrga sezgir — faqat kichik harfdagi ova hisobga olinadi.
Natijani ism bo'yicha alifbo tartibida saralang.
Jadval: doctors
| Ustun | Turi |
|---|---|
| id | INT PK |
| full_name | VARCHAR |
| specialty | VARCHAR |
Namuna ma'lumotlar
sample-basic
doctors
| idINT | full_nameVARCHAR(60) | specialtyVARCHAR(50) |
|---|---|---|
| 1 | Nodirova Dilbar | Kardiolog |
| 2 | Aliyev Botir | Nevrolog |
| 3 | Karimova Aziza | Terapevt |
| 4 | Yusupov Jahon | Xirurg |
Kutilgan natija
| full_name | specialty |
|---|---|
| Karimova Aziza | Terapevt |
| Nodirova Dilbar | Kardiolog |
sample-one-match
doctors
| idINT | full_nameVARCHAR(60) | specialtyVARCHAR(50) |
|---|---|---|
| 1 | Salimova Malika | Pediatr |
| 2 | Karimov Aziz | Xirurg |
Kutilgan natija
| full_name | specialty |
|---|---|
| Salimova Malika | Pediatr |
sample-case
doctors
| idINT | full_nameVARCHAR(60) | specialtyVARCHAR(50) |
|---|---|---|
| 1 | OVAliyeva Katta | Terapevt |
| 2 | Rahimova Feruza | Kardiolog |
Kutilgan natija
| full_name | specialty |
|---|---|
| Rahimova Feruza | Kardiolog |
O'xshash masalalar
Konsol
Natijani ko'rish uchun so'rovni ishga tushiring.