dannerQuick SQL Exploration copy
Updated 2023-03-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
-- forked from 51afd128-d3c9-47c5-8942-7da4834e120d
-- NOTES
-- Click the DB icon to explore available tables
-- tables with the 'ez_' prefix are the easiest to work with!
-- tables with the 'fact_' prefix are event based
-- tables with the 'dim_' prefix are descriptive
-- Comment Note:
-- highlight a chunk and use CMD + / to comment in or out multiple lines
-------------------------------------------------------
----- General Structure (not a real query!)
-------------------------------------------------------
-- select
-- table_1.column_name
-- from
-- table_1
-- where
-- some_condition = true
-------------------------------------------------------
----- General Structure w/ Join (not a real query!)
-------------------------------------------------------
-- select
-- table_1.column_name,
-- table_2.column_name
-- from
-- table_1
-- left join table_2 on table_1.column_1 = table_2.column_2
-- where
-- some_condition = true
-------------------------------------------------------
Run a query to Download Data