87. Rekursiv: yo'qolgan hisob-faktura raqamlari
QiyinHisob-fakturalar ketma-ket raqamlanishi kerak, lekin ba'zilari yo'qolgan.
Mavjud eng kichik va eng katta raqam oralig'ida yo'q bo'lgan raqamlarni toping.
Ustun: missing_number.
Saralash: o'sish.
Jadval: invoices
| Ustun | Turi |
|---|---|
| number | INT PK |
| client_name | VARCHAR |
Namuna ma'lumotlar
sample
invoices
| numberINT | client_nameVARCHAR(60) |
|---|---|
| 1 | Aziz |
| 2 | Nilufar |
| 5 | Bekzod |
Kutilgan natija
| missing_number |
|---|
| 3 |
| 4 |
sample-full
invoices
| numberINT | client_nameVARCHAR(60) |
|---|---|
| 100 | Aziz Karimov |
| 101 | Nilufar Rahimova |
| 104 | Bekzod Tursunov |
| 105 | Malika Yusupova |
| 106 | Sardor Nazarov |
| 110 | Dilnoza Ergasheva |
| 111 | Jasur Qodirov |
| 115 | Kamola Saidova |
| 116 | Otabek Mirzayev |
| 117 | Zilola Hamidova |
| 120 | Rustam Aliyev |
Kutilgan natija
| missing_number |
|---|
| 102 |
| 103 |
| 107 |
| 108 |
| 109 |
| 112 |
| 113 |
| 114 |
| 118 |
| 119 |
sample-extra
invoices
| numberINT | client_nameVARCHAR(60) |
|---|---|
| 12 | Rustam Aliyev |
| 6 | Aziz Karimov |
| 5 | Jasur Qodirov |
| 7 | Bekzod Tursunov |
| 3 | Malika Yusupova |
| 9 | Nilufar Rahimova |
| 4 | Aziz |
| 2 | Otabek Mirzayev |
| 1 | Kamola Saidova |
Kutilgan natija
| missing_number |
|---|
| 8 |
| 10 |
| 11 |
O'xshash masalalar
Konsol
Natijani ko'rish uchun so'rovni ishga tushiring.