Type SQL, then Shift-Enter. Ctrl-space for more options.
pizzeriaDB
SELECT Category
, Size
, avg(Price) as avg_price
, count(*) as num_products
FROM products
GROUP BY Category
, "Size"
pizzeriaDB
SELECT *
FROM products
pizzeriaDB
SELECT count(Category)
FROM products
GROUP BY (Size)
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.