Har bir shahardan nechta talaba

Easy 100 ball SQL 1000 ms admin

Har bir shahar uchun u yerdan kelgan talabalar sonini chiqaring.

Namunaviy ma‘lumotlar

students· 10 qator

id integer	name text	group_name text	city text	birth_year integer	score integer
1	Kamola Karimov	IT-22	Samarqand	2005	79
2	Alisher Aliyev	MT-21	Samarqand	2007	70
3	Aziza Nazarov	IT-21	Toshkent	2003	56
4	Sevara Xolmatov	IT-22	Samarqand	2007	85
5	Sardor Toshmatov	IT-21	Buxoro	2007	92
6	Dilnoza Rahimov	IT-21	Samarqand	2006	71
7	Doniyor Yusupov	MT-21	Buxoro	2007	60
8	Aziza Sobirov	IT-21	Samarqand	2004	86
9	Akmal Nazarov	IT-22	Samarqand	2006	89
10	Hamid Karimov	MT-21	Andijon	2007	97

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

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