The avatar for @paul-b2
Paul B
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 Billingcountry as country
from invoices;
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
Insert cell
chinook.db
select customerID as ID, FirstName, Country from customers
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
chinook.db
--This is how you format Comments
select *
from invoices
where Billingcountry ="Germany" or Billingcountry ="France";
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 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 and US
select name, unitprice
from tracks
where unitprice in (0.99);
Insert cell
Insert cell
Insert cell
chinook.db
select name, unitprice
from tracks

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
--your code goes here

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;
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