4. 3+ ketma-ket kun kirgan foydalanuvchilar
Qiyinlogins (user_id, login_date) jadvali foydalanuvchi kirishlarini saqlaydi. Bir kunda bir foydalanuvchi bir necha marta kirgan bo'lishi mumkin (takror sanalar bo'lishi mumkin).
Vazifa: kamida 3 kun ketma-ket (uzluksiz) kirgan user_id larni toping. Natija ustuni: user_id, user_id bo'yicha o'sish tartibida.
Jadval: logins
| Ustun | Turi |
|---|---|
| user_id | INT |
| login_date | DATE |
Namuna ma'lumotlar
sample-main
logins
| user_idINT | login_dateDATE |
|---|---|
| 1 | 2025-01-01 |
| 1 | 2025-01-02 |
| 1 | 2025-01-03 |
| 2 | 2025-01-01 |
| 2 | 2025-01-03 |
Kutilgan natija
| user_id |
|---|
| 1 |
sample-dup
logins
| user_idINT | login_dateDATE |
|---|---|
| 5 | 2025-02-01 |
| 5 | 2025-02-01 |
| 5 | 2025-02-02 |
| 5 | 2025-02-03 |
| 5 | 2025-02-04 |
Kutilgan natija
| user_id |
|---|
| 5 |
sample-none
logins
| user_idINT | login_dateDATE |
|---|---|
| 7 | 2025-03-01 |
| 7 | 2025-03-02 |
| 8 | 2025-03-05 |
sample-exact2
logins
| user_idINT | login_dateDATE |
|---|---|
| 9 | 2025-07-01 |
| 9 | 2025-07-02 |
O'xshash masalalar
Konsol
Natijani ko'rish uchun so'rovni ishga tushiring.