sql tekshiruvi laboratoriyasi

DOC 2 sahifa 28,0 KB Bepul yuklash

2 sahifa

FaylHub.uz

Telegram orqali yuklab olish

Hajm 28,0 KB

Fayl turi DOC

Sahifalar 2

Yangilangan Dek 2025

Sahifa ko'rinishi (2 sahifa)

Pastga aylantiring 👇

1 / 2

ma’lumotlar tahlilchisi bo‘ling 1-lobaratoriya 1.select* from invoice where invoicedate like '2013%' 2.select firstname, lastname, country from customer where ((country='brazil')or(country='canada')or(country='india')or(country='sweden')) 3.select t.name, t.composer, a.title from album as a join track as t on t.albumid=a.albumid where t.name like "a%" and t.composer is not null; 4.select c.firstname, c.lastname, i.total from customer c join invoice i on c.customerid=i.customerid order by i.total desc limit 10 2-laboratoriya 1.select billingcountry, count(invoicedate) as invoices from invoice group by billingcountry order by invoices desc; 2. select billingcity, max(totalsum) as total from ( select billingcity, sum(total) as totalsum from invoice group by billingcity); 3. select c.customerid, c.firstname, c.lastname, sum(i.total) as totalspent from customer c, invoice i where c.customerid=i.customerid group by (i.customerid) order by totalspent desc limit 1; 4. select distinct email,firstname,lastname,e.name from customer a,invoice b,invoiceline c,track d,genre e where a.customerid=b.customerid and b.invoiceid=c.invoiceid and c.trackid=d.trackid and d.genreid=e.genreid and e.name = 'rock' order by email; 5. with tab1 as ( select c.customerid, …

2 / 2

Ko'proq o'qimoqchimisiz?

Barcha 2 sahifani Telegram orqali bepul yuklab oling.

To'liq faylni yuklab olish

"sql tekshiruvi laboratoriyasi" haqida

ma’lumotlar tahlilchisi bo‘ling 1-lobaratoriya 1.select* from invoice where invoicedate like '2013%' 2.select firstname, lastname, country from customer where ((country='brazil')or(country='canada')or(country='india')or(country='sweden')) 3.select t.name, t.composer, a.title from album as a join track as t on t.albumid=a.albumid where t.name like "a%" and t.composer is not null; 4.select c.firstname, c.lastname, i.total from customer c join invoice i on c.customerid=i.customerid order by i.total desc limit 10 2-laboratoriya 1.select billingcountry, count(invoicedate) as invoices from invoice group by billingcountry order by invoices desc; 2. select billingcity, max(totalsum) as total from ( select billingcity, sum(total) as totalsum from invoice group by billingcity); 3. select c.customeri...

Bu fayl DOC formatida 2 sahifadan iborat (28,0 KB). "sql tekshiruvi laboratoriyasi"ni yuklab olish uchun chap tomondagi Telegram tugmasini bosing.

Teglar: sql tekshiruvi laboratoriyasi DOC 2 sahifa Bepul yuklash Telegram