The avatar for @credmond
Charles Redmond
Public
Edited
Mar 9, 2023
2
Insert cell
Insert cell
db = DuckDBClient.of({
batting:FileAttachment("Batting.csv"),
people:FileAttachment("People.csv")
})
Insert cell
db
SELECT playerID,teamID,yearID,HR FROM Batting
WHERE HR >= 55
ORDER BY HR DESC
Insert cell
bigSeasons
Insert cell
db
SELECT playerID,fsum(HR) AS careerHR FROM Batting
GROUP BY playerID
HAVING careerHR >= 500
ORDER BY careerHR DESC
Insert cell
db
SELECT nameFirst,nameLast,teamID,yearID,HR
FROM batting,people
WHERE HR >= 55 AND batting.playerID = people.playerID
ORDER BY HR DESC
Insert cell
db
SELECT max(nameFirst),max(nameLast),fsum(HR) AS careerHR
FROM batting,people
WHERE batting.playerID = people.playerID
GROUP BY batting.playerID
HAVING careerHR >= 500
ORDER BY careerHR 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