The avatar for @lukehart54
lukehart54
Published
Edited
Oct 11, 2022
1
Insert cell
Insert cell
Insert cell
database = FileAttachment("chinook.db").sqlite()
Insert cell
Insert cell
database
Type SQL, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell
Insert cell
database
SELECT Name FROM tracks
ORDER BY Name ASC
Insert cell
Insert cell
database
SELECT * FROM albums
WHERE AlbumId > 5 AND AlbumId < 11
Insert cell
Insert cell
database
SELECT Name FROM artists WHERE ArtistId==(SELECT artistId FROM albums WHERE Title like '%Bark at the Moon%')
Insert cell
Insert cell
database
SELECT * FROM tracks
ORDER BY Milliseconds DESC
LIMIT 1 OFFSET 2
Insert cell
Insert cell
database
SELECT * FROM tracks
WHERE UnitPrice < 2 AND UnitPrice > 1
Insert cell
Insert cell
database
SELECT * FROM albums WHERE ArtistId=(SELECT ArtistId FROM artists WHERE Name='Queen')
Insert cell
Insert cell
database
SELECT Name FROM artists WHERE ArtistId= (SELECT ArtistId FROM albums WHERE Title='Let There Be Rock')
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