The avatar for @nypl-intro-to-sql2
NYPL Intro to SQL
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 Name
from artists;
Insert cell
Insert cell
chinook.db
select billingcountry as country
from invoices;
Insert cell
Insert cell
chinook.db
select distinct billingcountry as TotalCountries
from invoices;
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 billingcountry = "Germany";
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-08' and '2012-01-01';
Insert cell
chinook.db
select name, milliseconds
from tracks
where milliseconds between "250000" and "300000" or milliseconds between "350000" and "400000";
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 all invoices from germany, france, usa
select *
from invoices
where billingcountry in ("Germany", "France", "USA");

Insert cell
Insert cell
Insert cell
chinook.db
select invoiceid, invoicedate, billingcountry, total
from invoices
where billingcountry in ("USA", "Canada") and Total >8;
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
Insert cell
Insert cell
chinook.db
--your code goes here
select composer, count (composer)
from tracks
group by composer
order by composer asc;
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 artists.name 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