17 / 28

O‘rtacha bali 70 dan yuqori guruhlar

Easy 100 ball SQL 1000 ms admin

O‘rtacha bali 70 dan katta bo‘lgan guruhlarni va ulardagi talabalar sonini chiqaring.

Maslahat: guruhlangan natijani HAVING bilan saralang.

Namunaviy ma‘lumotlar

students· 10 qator

id integer	name text	group_name text	city text	birth_year integer	score integer
1	Nilufar Aliyev	IT-21	Andijon	2001	87
2	Umida Aliyev	IT-21	Buxoro	2002	48
3	Bobur Mirzayev	IT-21	Toshkent	2006	86
4	Bekzod Ergashev	MT-21	Buxoro	2002	46
5	Hamid Rahimov	IT-21	Buxoro	2007	71
6	Doniyor Qodirov	IT-21	Samarqand	2004	81
7	Sevara Sobirov	MT-21	Andijon	2003	85
8	Nodir Yusupov	MT-21	Samarqand	2001	56
9	Aziza Yusupov	IT-22	Samarqand	2007	55
10	Otabek Umarov	IT-22	Buxoro	2005	70

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, students_count.

IT-21

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