The avatar for @credmond
Charles Redmond
Public
aaa-Database550Fall23
Edited
Nov 8, 2023
2
Insert cell
Insert cell
batting = FileAttachment("Batting.csv").csv({typed:true})
Insert cell
people = FileAttachment("People.csv").csv({typed:true})
Insert cell
db = DuckDBClient.of({
batting:batting,
people:people
})
Insert cell
db
SELECT playerID,
CASE
WHEN (
SELECT count(*)
FROM batting
WHERE playerID = people.playerID AND yearID >= 2000
) = 0 THEN -1
ELSE (
SELECT sum(HR)
FROM batting
WHERE playerID = people.playerID AND yearID >= 2000
)
END total
FROM people
WHERE total != -1
ORDER BY total DESC
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