Public
Edited
Jul 27, 2023
31 forks
Importers
25 stars
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
pizzeriaDB = DuckDBClient.of({
orders: FileAttachment("orders@1.parquet"),
stores: FileAttachment("stores@1.csv"),
customers: FileAttachment("customers@1.csv"),
products: FileAttachment("products@1.csv"),
order_items: FileAttachment("orderItems@1.parquet"),
// Views
orders_by_product_day: FileAttachment("orders_by_product_day.csv"),
california_stores: FileAttachment("california_stores.csv"),
nevada_stores: FileAttachment("nevada_stores.csv"),
california_daily_orders: FileAttachment("california_daily_orders.csv"),
nevada_daily_orders: FileAttachment("nevada_daily_orders.csv")
})
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
pizzeriaDB
Type Table, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
pizzeriaDB
SELECT c.longitude as longitude
, c.latitude as latitude
, c.id as customerId
, o.storeId as storeId
, COUNT(*) as orders
FROM orders as o
JOIN customers as c
ON o.customerId = c.id
GROUP BY 1, 2, 3, 4
Insert cell
pizzeriaDB
select * from stores
Insert cell
Insert cell
Insert cell
pizzeriaDB
SELECT orderDate::date as order_date
, stores.id as store_id
, count(distinct orders.id) as orders
, sum(products.Price::int)::int as revenue
FROM orders
JOIN order_items
ON orders.id = order_items.orderID
JOIN products
ON order_items.SKU = products.SKU
JOIN stores
ON orders.storeId = stores.id
WHERE stores.state = 'California'
GROUP BY 1, 2
ORDER BY 1, 2
Insert cell
pizzeriaDB
SELECT *
FROM stores
WHERE stores.state = 'California'
Insert cell
pizzeriaDB
SELECT *
FROM stores
WHERE stores.state = 'Nevada'
Insert cell
pizzeriaDB
SELECT orderDate::date as order_date
, stores.id as store_id
, count(distinct orders.id) as orders
, sum(products.Price::int)::int as revenue
FROM orders
JOIN order_items
ON orders.id = order_items.orderID
JOIN products
ON order_items.SKU = products.SKU
JOIN stores
ON orders.storeId = stores.id
WHERE stores.state = 'Nevada'
GROUP BY 1, 2
ORDER BY 1, 2
Insert cell
Insert cell
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