The avatar for @credmond
Charles Redmond
Public
aaa-Database350Fall23
Edited
Oct 31, 2023
7 forks
3
aaa-Database350Fall23
Plotting TemplateSine ApplicationNYC ExampleStock PricesQuiz 9Grad Case Statement Quiz and AnalyticsThe Case Statement
Grad Quiz
Quiz 7 and Correlated SubqueriesChinook DatabaseQuiz 6SubqueriesSakilaQuiz 5SetsH VS. SOData VizJoinsBasic QueriesCreating and Populating a Database
Insert cell
Insert cell
Insert cell
Insert cell
hallFile = FileAttachment("HallOfFame.csv").csv({typed:true})
Insert cell
Insert cell
db
SELECT DISTINCT playerID
FROM college
WHERE 250 < (
SELECT weight
FROM people
WHERE playerID = college.playerID
)
Insert cell
db
SELECT playerID
FROM people
WHERE 250 < (
SELECT weight
FROM college
WHERE playerID = people.playerID
)
Insert cell
db
SELECT DISTINCT playerID
FROM college
WHERE 1 = (
SELECT count(*)
FROM hall
WHERE playerID = college.playerID
) AND 'Y' = (
SELECT inducted
FROM hall
WHERE playerID = college.playerID
)
Insert cell
db
SELECT DISTINCT playerID
FROM hall
GROUP BY playerID
HAVING count(*) = 1 AND max(inducted) = 'Y' AND EXISTS (
SELECT *
FROM college
WHERE playerID = hall.playerID
)
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