The avatar for @credmond
Charles Redmond
Public
aaa-Database350Fall23
Edited
Oct 3, 2023
2 forks
1
aaa-Database350Fall23
Plotting TemplateSine ApplicationNYC ExampleStock PricesQuiz 9Grad Case Statement Quiz and AnalyticsThe Case StatementGrad QuizQuiz 7 and Correlated SubqueriesChinook DatabaseQuiz 6Subqueries
Sakila
Quiz 5SetsH VS. SOData VizJoinsBasic QueriesCreating and Populating a Database
Insert cell
Insert cell
Insert cell
db = DuckDBClient.of({
inventory:inventoryFile
})
Insert cell
db
SELECT DISTINCT film_id
FROM inventory
WHERE store_id = 1
EXCEPT
SELECT DISTINCT film_id
FROM inventory
WHERE store_id = 2
Insert cell
db
SELECT DISTINCT film_id
FROM inventory
WHERE store_id = 2
EXCEPT
SELECT DISTINCT film_id
FROM inventory
WHERE store_id = 1
Insert cell
db
SELECT DISTINCT film_id
FROM inventory
WHERE store_id = 1
INTERSECT
SELECT DISTINCT film_id
FROM inventory
WHERE store_id = 2
Insert cell
db
SELECT DISTINCT film_id
FROM inventory
WHERE store_id = 1
UNION
SELECT DISTINCT film_id
FROM inventory
WHERE store_id = 2
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