The avatar for @larnsce
Lars Schöbitz
Public
Edited
Apr 13, 2023
Insert cell
Insert cell
db
SELECT m.name
, COUNT(*) as count
FROM get_fit_now_member m
JOIN get_fit_now_check_in c
ON m.id = c.membership_id
GROUP BY m.name
ORDER BY count DESC
Insert cell
db
Type Table, then Shift-Enter. Ctrl-space for more options.

Insert cell
db
Type Table, then Shift-Enter. Ctrl-space for more options.

Insert cell
db
SELECT address_street_name
, count(*) as count
FROM person
GROUP BY address_street_name
ORDER BY count DESC
Insert cell
db
Type Table, then Shift-Enter. Ctrl-space for more options.

Insert cell
db
Type Table, then Shift-Enter. Ctrl-space for more options.

Insert cell
import {mysteryDuck as db} from "@observablehq/sql-murder-mystery-in-duckdb"
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