Har bir mijoz uchun ismini katta harflarda va ismidagi belgilar sonini chiqaring (UPPER, LENGTH).
Namunaviy ma‘lumotlar
| id integer | name text | city text | phone text |
|---|---|---|---|
| 1 | Yusuf Aliyev | Toshkent | +998908254718 |
| 2 | Alisher Umarov | Toshkent | +998906909960 |
| 3 | Shahzod Sobirov | Samarqand | +998905581716 |
| 4 | Akmal Umarov | Buxoro | +998903032797 |
| 5 | Rustam Yusupov | Samarqand | NULL |
| 6 | Aziz Ergashev | Buxoro | +998908111843 |
| 7 | Elyor Xolmatov | Buxoro | +998906966300 |
Jadval tuzilishi (CREATE TABLE)
CREATE TABLE customers (id INTEGER PRIMARY KEY, name TEXT, city TEXT, phone TEXT);
Natija
Ikki ustun: name_upper, name_length.
Namunaviy ma‘lumotlarda kutilgan natija
| YUSUF ALIYEV | 12 |
| ALISHER UMAROV | 14 |
| SHAHZOD SOBIROV | 15 |
| AKMAL UMAROV | 12 |
| RUSTAM YUSUPOV | 14 |
| AZIZ ERGASHEV | 13 |
| ELYOR XOLMATOV | 14 |
Qatorlar tartibi ahamiyatsiz, ustunlar tartibi muhim. Yechim yashirin, kattaroq ma‘lumotlarda ham tekshiriladi.