The avatar for @credmond
Charles Redmond
Public
aaa-Database550Fall23
Edited
Sep 7, 2023
Fork of Joins
•
3 forks
3
aaa-Database550Fall23
Plotting TemplateClass Exercise Part 2Make-up QuizViews and AnalyticsThe CASE StatementCASE Part 2Correlated SubQueriesQuiz 6Chinook ProblemsSubqueriesSets Part 2SetsH VS SO ApplicationHomerun ApplicationPlotting Tutorial
Data Viz
JoinsBaseball DatabaseCreating and Populating a Database
Insert cell
Insert cell
db
SELECT max(nameFirst),
max(nameLast),
replace(batting.yearID,',',''),
sum(batting.HR) AS seasonHR,
IF(
max(name) == min(name),
max(name),
concat(min(name),'/',max(name))
)
FROM batting INNER JOIN people
ON batting.playerID = people.playerID
INNER JOIN teams
ON batting.teamID = teams.teamID AND batting.yearID = teams.yearID
GROUP BY batting.playerID,batting.yearID
HAVING seasonHR >= 50
ORDER BY seasonHR DESC
Insert cell
Insert cell
Insert cell
db
SELECT DISTINCT name
FROM teams
Insert cell
nameArray = nameQuery.map(record => record.name).sort()
Insert cell
Insert cell
db = DuckDBClient.of({
batting:battingFile,
people:peopleFile,
teams:teamsFile
})
Insert cell
db
ALTER TABLE batting
ALTER yearID TYPE USMALLINT
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
x = [2,5,4,8,0]
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