Running Queries and the Results Pane
Let's write some queries to generate some visuals for our dataset.
We'll cover the following...
Anatomy of the results pane
With our newly installed car_crash
database, we are now set to write SQL queries and create interesting tabular and visual results. First, let’s open a new query from the server dashboard using the car_crash
database, as shown below:
Next, enter the query:
Press + to interact
select distinct BOROUGHfrom edw.D_LOCATION
Then click on “Run”. You should now see the query results, as shown below:
The above results pane provides the query results, which in this case lists all the boroughs contained in the D_LOCATION
table (which in ...