Toshkentlik talabalar

Beginner 50 ball SQL 1000 ms admin

Shahri Toshkent bo‘lgan talabalarning ismlarini chiqaring.

Namunaviy ma‘lumotlar

students· 10 qator

id integer	name text	group_name text	city text	birth_year integer	score integer
1	Dilnoza Ergashev	IT-22	Samarqand	2001	74
2	Temur Sobirov	IT-22	Samarqand	2001	86
3	Yusuf Xolmatov	MT-21	Toshkent	2001	83
4	Laylo Ergashev	IT-21	Samarqand	2005	53
5	Nilufar Ergashev	IT-21	Toshkent	2006	55
6	Bobur Xolmatov	MT-21	Buxoro	2005	70
7	Aziza Sobirov	IT-22	Toshkent	2004	56
8	Laylo Mirzayev	IT-22	Samarqand	2006	71
9	Otabek Umarov	IT-22	Buxoro	2005	85
10	Aziz Umarov	IT-21	Andijon	2004	100

Jadval tuzilishi (CREATE TABLE)

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

Bitta ustun: name.

Yusuf Xolmatov

Nilufar Ergashev

Aziza Sobirov

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