Guruhlarning o‘rtacha bali

Easy 100 ball SQL 1000 ms admin

Har bir guruh (group_name) uchun talabalarining o‘rtacha balini 2 xonagacha yaxlitlab (ROUND(..., 2)) chiqaring.

Namunaviy ma‘lumotlar

students· 10 qator

id integer	name text	group_name text	city text	birth_year integer	score integer
1	Madina Umarov	IT-22	Samarqand	2003	71
2	Ilhom Ergashev	MT-21	Buxoro	2002	54
3	Alisher Karimov	MT-21	Andijon	2002	97
4	Zarina Ergashev	IT-22	Andijon	2002	46
5	Umida Karimov	IT-22	Andijon	2006	78
6	Rustam Xolmatov	IT-22	Toshkent	2001	85
7	Laylo Xolmatov	MT-21	Andijon	2007	56
8	Bekzod Qodirov	IT-22	Buxoro	2001	95
9	Nilufar Yusupov	MT-21	Toshkent	2001	70
10	Temur Qodirov	IT-21	Samarqand	2001	86

Jadval tuzilishi (CREATE TABLE)

CREATE TABLE students (id INTEGER PRIMARY KEY, name TEXT, group_name TEXT, city TEXT, birth_year INTEGER, score INTEGER);

Ikki ustun: group_name, avg_score.

Qatorlar tartibi ahamiyatsiz, ustunlar tartibi muhim. Yechim yashirin, kattaroq ma‘lumotlarda ham tekshiriladi.

Ranglar Shrift O‘lcham 14px

Chekinishbo‘sh joy soni

2 4

Uzun qatorlarni o‘rash Vim rejimi Til shabloniMuharrir bo‘sh bo‘lsa qo‘yiladi

Kodingiz shu brauzerda saqlanadi.

Kirish