The avatar for @pandafulmanda
Amanda Shih
Public
houston data jams: workshops: Intro to SQL
Edited
Mar 16, 2024
1 star
Insert cell
Insert cell
Insert cell
Insert cell
neighbors_data
SELECT
check_details."Opened Date",
COUNT(check_details."Check #") AS “CheckCount”,
SUM(check_details."Total") as “DailyTotal”
FROM check_details
GROUP BY check_details."Opened Date"
ORDER BY check_details."Opened Date"
Insert cell
Insert cell
neighbors_data
SELECT
SUM("Net Price") AS "Total $",
order_details."Service",
"Menu Group"
FROM
item_selection_details
JOIN
order_details
ON
item_selection_details."Order Id" = order_details."Order Id"
WHERE
order_details."Service" IS NOT NULL AND
"Menu Group" IN ('Pizza', 'Wine', 'Beer', 'Shots')
GROUP BY
order_details."Service",
"Menu Group"
ORDER BY
order_details."Service",
"Menu Group"
Insert cell
Insert cell
neighbors_data
SELECT
SUM(item_selection_details."Net Price") AS "Total $",
item_selection_details."Service",
item_selection_details."Menu Group"
,
modifiers_selection_details."Modifier"
FROM
item_selection_details
JOIN
modifiers_selection_details
ON
item_selection_details."Order Id" = modifiers_selection_details."Order Id"
GROUP BY
item_selection_details."Service",
item_selection_details."Menu Group"
,
modifiers_selection_details."Modifier"
Insert cell
Insert cell
neighbors_data
Type SQL, then Shift-Enter. Ctrl-space for more options.

Insert cell
separator
Insert cell
import { neighbors_data, separator } from "@pandafulmanda/workshop00--setup-database"
Insert cell
neighbors_data.describe()
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