The avatar for @samchencode
samchencode
Public
ClickHouse Tutorial Series
Edited
Feb 28, 2023
8
ClickHouse Tutorial Series
❶ What Are Databases?❷ Intro To SQL Syntax
❸ Table Relationships & Joins
❹ Aggregation, Subqueries, Windows❺ Creating Tables & Inserting Data❻ Very Briefly: Integration, Optimization, Configuration
Insert cell
Insert cell
client
SELECT * FROM stock LIMIT 10
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
client
SELECT
m.id AS menu_id,
mp.id AS menu_page_id,
m.name AS menu_name,
mp.full_height AS full_height,
mp.full_width AS full_width
FROM menu_page AS mp
INNER JOIN menu AS m
ON mp.menu_id = m.id
WHERE menu_name != ''
LIMIT 30;
Insert cell
Insert cell
client
SELECT
mp.menu_id,
mp.page_number,
d.name AS dish_name,
mi.price AS dish_price
FROM dish AS d
INNER JOIN menu_item AS mi
ON d.id = mi.dish_id
INNER JOIN menu_page AS mp
ON mp.id = mi.menu_page_id
WHERE dish_price != 0
ORDER BY mp.menu_id, mp.page_number
LIMIT 50
Insert cell
Insert cell
Insert cell
client
SELECT 'Hello World'; -- REPLACE THIS WITH YOUR QUERY
Insert cell
Insert cell
client
SELECT 'Hello World'; -- REPLACE THIS WITH YOUR QUERY
Insert cell
Insert cell
client
SELECT 'Hello World'; -- REPLACE THIS WITH YOUR QUERY
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