A’lochilar

Beginner 50 ball SQL 1000 ms admin

Bali 85 va undan yuqori bo‘lgan talabalarning ismi va balini chiqaring.

Namunaviy ma‘lumotlar

students· 10 qator

id integer	name text	group_name text	city text	birth_year integer	score integer
1	Bekzod Ergashev	IT-21	Samarqand	2006	86
2	Sardor Mirzayev	IT-21	Andijon	2006	53
3	Sardor Ergashev	MT-21	Andijon	2003	50
4	Sardor Nazarov	IT-21	Toshkent	2007	64
5	Umida Aliyev	IT-22	Toshkent	2004	70
6	Rustam Aliyev	IT-21	Andijon	2005	70
7	Zarina Karimov	IT-22	Buxoro	2004	53
8	Aziza Mirzayev	IT-22	Samarqand	2002	71
9	Hamid Qodirov	IT-21	Buxoro	2004	56
10	Aziz Aliyev	MT-21	Toshkent	2002	85

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

Bekzod Ergashev	86
Aziz Aliyev	85

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