The avatar for @nypl-sql-class
NYPL SQL Class
Public
Edited
Apr 24
Fork of Intro to SQL_Starter Code
2
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
chinook.db
select DISTINCT BillingCountry
from invoices;
Insert cell
Insert cell
chinook.db
Type SQL, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell
chinook.db
Type SQL, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell
Insert cell
chinook.db
Select customerid AS id, firstname, country
from customers;
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
chinook.db
select *
from invoices
where billingcity = "Berlin" OR billingcity = "Stuttgart";
Insert cell
Insert cell
Insert cell
chinook.db
select *
from invoices
where billingcountry = "Germany" and billingcity <> "Berlin" ;
Insert cell
Insert cell
Insert cell
chinook.db
select InvoiceDate as Date, CustomerId, Total
from invoices
where Date between '2010-01-01' AND '2012-01-01';
Insert cell
chinook.db
select name, Milliseconds
from tracks
where Milliseconds between 126511 and 205662 or Milliseconds between 299888 and 350111

Insert cell
Insert cell
Insert cell
chinook.db
select FirstName, LastName, Title
from employees
where Title in ('General Manager', 'Sales Manager', 'IT Manager');
Insert cell
chinook.db
select *
from invoices
where billingcountry in ('Germany', 'France', "USA")
Insert cell
chinook.db
select name, unitprice
from tracks
where unitprice = 1.99
Insert cell
Insert cell
Insert cell
chinook.db
--your code goes here

Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
chinook.db
select title, count(title) as numEmployees
from employees
group by title
Insert cell
Insert cell
Insert cell
chinook.db
select billingcountry, sum(total)
from invoices
group by billingcountry
Insert cell
Insert cell
chinook.db
select billingcountry, sum(total) as totalSales
from invoices
group by billingcountry
order by totalSales desc
Insert cell
chinook.db
select name
from artists
order by name asc
Insert cell
Insert cell
Insert cell
chinook.db
select *
from tracks
Insert cell
Insert cell
Insert cell
chinook.db
--your code goes here

Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
chinook.db
select artists.name, albums.title
from artists
inner join albums on artists.artistid = albums.artistid
order by albums.title asc
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
chinook.db
Type SQL, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell
Insert cell
chinook.db
--your code goes here

Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
chinook.db
Type SQL, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell

Purpose-built for displays of data

Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
Learn more