Select from Invoice where InvoiceDate between '2013-01-01' and '2014-01-01'

The Chinook database contains all invoices from the beginning of 2009 till the end of 2013. The employees at Chinook store are interested in seeing all invoices that happened in 2013 only. Using the Invoice table, write a query that returns all the info of the invoices in 2013.

select *

from Invoice

where InvoiceDate between '2013-01-01' and '2014-01-01';

The Chinook team decided to run a marketing campaign in Brazil, Canada, india, and Sweden. Using the customer table, write a query that returns the first name, last name, and country for all customers from the 4 countries.

Select firstName, lastName, country

from Customer

where country in ('Brazil', 'Canada', 'India', 'Sweden');

Using the Track and Album tables, write a query that returns all the songs that start with the letter 'A' and the composer field is not empty. Your query should return the name of the song, the name of the composer, and the title of the album.

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 '';

The Chinook team would like to throw a promotional Music Festival for their top 10 cutomers who have spent the most in a single invoice. Write a query that returns the first name, last name, and invoice total for the top 10 invoices ordered by invoice total descending.

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