Skip to content

Instantly share code, notes, and snippets.

@Manuela82

Manuela82/Chinook.sql

Last active May 28, 2020 15:12
Show Gist options
  • Save Manuela82/c1de05782093a92273fb3da592e4ef55 to your computer and use it in GitHub Desktop.
Save Manuela82/c1de05782093a92273fb3da592e4ef55 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Chinook.sql
Select Name
From Artist;
Select *
From Invoice
Where Invoice.BillingCountry='Germany';
Select count (*)
From Album;
Select min(milliseconds)
From Track;
Select max(milliseconds)
From Track;
SELECT avg (UnitPrice), sum (UnitPrice)
From Track;
Select count (*)
From Customer
Where customer.Country='France';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment