11. O'rtachadan yuqori ball olgan talabalar
OsonUniversitet imtihon natijalari students jadvalida.
Bali umumiy o'rtachadan yuqori bo'lgan talabalarning name va grade
ustunlarini qaytaring.
Natijani ball bo'yicha kamayish tartibida saralang.
Jadval: students
| Ustun | Turi |
|---|---|
| id | INT PK |
| name | VARCHAR |
| grade | INT |
Namuna ma'lumotlar
sample-basic
students
| idINT | nameVARCHAR(50) | gradeINT |
|---|---|---|
| 1 | Aziz | 90 |
| 2 | Bek | 60 |
| 3 | Dilnoza | 75 |
| 4 | Kamola | 50 |
| 5 | Sherzod | 85 |
Kutilgan natija
| name | grade |
|---|---|
| Aziz | 90 |
| Sherzod | 85 |
| Dilnoza | 75 |
sample-all-equal
students
| idINT | nameVARCHAR(50) | gradeINT |
|---|---|---|
| 1 | A | 70 |
| 2 | B | 70 |
| 3 | C | 70 |
sample-two
students
| idINT | nameVARCHAR(50) | gradeINT |
|---|---|---|
| 1 | Low | 40 |
| 2 | High | 80 |
Kutilgan natija
| name | grade |
|---|---|
| High | 80 |
O'xshash masalalar
Konsol
Natijani ko'rish uchun so'rovni ishga tushiring.