Skip to content

Instantly share code, notes, and snippets.

View osamasarhan's full-sized avatar
🎣
let's catch gigantic fish

Osama Sarhan osamasarhan

🎣
let's catch gigantic fish
View GitHub Profile
@osamasarhan
osamasarhan / لاب1 تحليل بيانات
Created May 18, 2019 15:31
lab1-1MAC-DATA ANALYSIS TRACK
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