From invoice where invoiceDate like '2013%'


Download 2.53 Kb.
Sana17.06.2023
Hajmi2.53 Kb.
#1544579
Bog'liq
Malumotlar bazasi


SELECT*
FROM Invoice
WHERE InvoiceDate like '2013%'
SELECT FirstName, LastName, Country
FROM Customer
Where
((Country='Brazil')OR(Country='Canada')OR(Country='India')OR(Country='Sweden'))
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;
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
Download 2.53 Kb.

Do'stlaringiz bilan baham:




Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©fayllar.org 2024
ma'muriyatiga murojaat qiling