The avatar for @pandafulmanda
Amanda Shih
Public
houston data jams: workshops: Intro to SQL
Edited
Mar 16, 2024
Insert cell
Insert cell
Insert cell
Insert cell
neighbors_data
SELECT * FROM modifiers_selection_details;
Insert cell
neighbors_data
SELECT
order_details.*, -- get everything from order details
item_selection_details.*
, other_table.*
-- other_table.*
-- "Order Id",
-- "Net Price",
-- "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')
Insert cell
Insert cell
neighbors_data
Type SQL, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell
neighbors_data
SELECT
check_details."Item Description" AS "Ordered_Food_Drinks"
FROM check_details
LIMIT 10
Insert cell
Insert cell
neighbors_data
SELECT *
FROM check_details CD
INNER JOIN item_selection_details ISD
ON CD."Check Id" = ISD."Check Id"
LIMIT 10

Insert cell
Insert cell
neighbors_data
SELECT AVG(total) AS Avg_CheckAmt
FROM check_details
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