1 / 28

Talabalar ro‘yxati

Beginner 50 ball SQL 1000 ms admin

Universitet bazasida students jadvali bor. Barcha talabalarning ismi va shahrini chiqaring.

Namunaviy ma‘lumotlar

students· 10 qator

id integer	name text	group_name text	city text	birth_year integer	score integer
1	Bekzod Sobirov	IT-22	Andijon	2005	47
2	Vali Mirzayev	IT-21	Buxoro	2002	64
3	Sardor Nazarov	IT-21	Samarqand	2002	86
4	Madina Qodirov	IT-21	Buxoro	2002	70
5	Yusuf Umarov	MT-21	Samarqand	2002	85
6	Elyor Mirzayev	IT-22	Buxoro	2007	71
7	Bobur Ergashev	IT-22	Toshkent	2004	73
8	Kamola Qodirov	MT-21	Toshkent	2006	85
9	Otabek Sobirov	IT-21	Toshkent	2005	63
10	Yusuf Yusupov	IT-21	Samarqand	2002	56

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

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