sql tekshiruvi laboratoriyasi

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

This file contains 2 pages in DOC format (28.0 KB). To download "sql tekshiruvi laboratoriyasi", click the Telegram button on the left.