This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
test1 | |
Q1 | |
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. | |
SL1: | |
SELECT * | |
FROM Invoice | |
WHERE InvoiceDate BETWEEN '2013-01-01' AND '2014-01-01' ; | |
Q2 |