The avatar for @meuespaco
meuespaco
Public
Edited
Jun 15, 2023
Fork of SQL Course: Session 1
Insert cell
Insert cell
Insert cell
Insert cell
import { pizzeriaDB } from '@observablehq/pizza-paradise-data'
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
pizzeriaDB
SELECT * FROM customers
Insert cell
pizzeriaDB
SELECT * FROM products
Insert cell
Insert cell
Insert cell
pizzeriaDB
SELECT city
, zipcode
, state
FROM stores
Insert cell
pizzeriaDB
SELECT DISTINCT *
FROM products
Insert cell
Insert cell
Insert cell
Insert cell
pizzeriaDB
SELECT DISTINCT state
FROM stores
Insert cell
Insert cell
pizzeriaDB
SELECT DISTINCT state
, city
FROM stores
Insert cell
Insert cell
pizzeriaDB
select * from stores
Insert cell
Insert cell
pizzeriaDB
SELECT state
, count(*) as num_stores
FROM stores
GROUP BY state
Insert cell
pizzeriaDB
SELECT count(id)
FROM stores
Insert cell
Insert cell
pizzeriaDB
SELECT count(*)
FROM stores
Insert cell
pizzeriaDB
SELECT count(distinct (id))
FROM orders
Insert cell
pizzeriaDB
SELECT count(*)
FROM stores
GROUP BY state
Insert cell
pizzeriaDB
SELECT count(distinct state) as num_stores
FROM stores
Insert cell
Insert cell
pizzeriaDB
SELECT count(*) as num_products
FROM products
Insert cell
Insert cell
pizzeriaDB
SELECT Category
, avg(Price) as avg_price
, count(*) as num_products
FROM products
GROUP BY Category
Insert cell
Insert cell
pizzeriaDB
Type SQL, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell
pizzeriaDB
SELECT Category
, Size
, avg(Price) as avg_price
, count(*) as num_products
FROM products
GROUP BY Category
, "Size"
Insert cell
pizzeriaDB
SELECT *
FROM products
Insert cell
pizzeriaDB
SELECT count(Category)
FROM products
GROUP BY (Size)
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
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