The avatar for @samchencode
samchencode
Public
ClickHouse Tutorial Series
Edited
Feb 28, 2023
8
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

One platform to build and deploy the best data apps

Experiment and prototype by building visualizations in live JavaScript notebooks. Collaborate with your team and decide which concepts to build out.
Use Observable Framework to build data apps locally. Use data loaders to build in any language or library, including Python, SQL, and R.
Seamlessly deploy to Observable. Test before you ship, use automatic deploy-on-commit, and ensure your projects are always up-to-date.
Learn more