1.
select *
from Invoice
where InvoiceDate between '2013-01-01' and '2014-01-01';
2
Select firstName, lastName, country
from Customer
where country in ('Brazil', 'Canada', 'India', 'Sweden');
3
Select Track.name, Track.Composer, Album.title
From track
JOIN Album
ON track.AlbumId=Album.AlbumId
WHERE Track.name like 'A%' AND Track.composer not LIKE '';
4
SELECT C.Firstname, C.Lastname, I.Total
FROM Customer AS C
JOIN Invoice AS I
ON C.CustomerId=I.CustomerId
ORDER BY I.total DESC
LIMIT 10
Do'stlaringiz bilan baham: |