The avatar for @rossstewart12
Ross Stewart
Public
Edited
Mar 13, 2023
2
Insert cell
Insert cell
db = DuckDBClient.of({
batting:FileAttachment("Batting.csv"),
people:FileAttachment("People.csv")
})
Insert cell
db
SELECT playerID,yearID,teamID,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,yearID,teamID,HR
FROM batting,people
WHERE batting.playerID == people.playerID AND HR >= 55
ORDER BY HR DESC
Insert cell
db
SELECT max(CONCAT(nameFirst,' ',nameLast)) AS name,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