Select fish,rpad(fish,5,' ') from xodim

Muhammad al-Xorazmiy nomidagi Toshkent axborot texnologiyalari universiteti telekommunikatsiya texnologiyalari fakulteti dbm 004 guruh talabasi Nuriddinov Muhammadsodiqning malumotlar bazasi fanidan 4-amaliy topshirigi

Lover-ustun elementlarini kichik harfga otkazadi SELECT lower(first_name) FROM customers;

Upper- ustun elementlarini katta harfga otkazadi SELECT upper(manzili) FROM xodim;

select fish,rpad(fish,5,'...') from xodim funksiya online compilerda ishlamaydi lpad ham

SELECT REPLACE("first_name", "last_name", "country") from Customers;

Reverse- ustundagi malumotlarni teskarilaydi SELECT REVERSE(item)
FROM Orders;

SELECT UCASE(item) AS barcha_qurilmalar
FROM orders; online kompilatorda ishlamaydi

SELECT FORMAT(amount, '***') from orders;

Length- ustundagi elementlar hajmini belgilaydi SELECT LENGTH(first_name) AS ismdagi_elementlari_soni
FROM Customers;

Select customer_id, first_name, last_name, LTRiM(last_name), RTRiM(last_name)
from customers;