Skip to content

Mission 6 - Advanced queries with SQL

Learning Objective

In this mission we learn how to execute custom queries on the data.

Knowledge requirement

Basic knowledge of SQL.

Data

Please download the required dataset we will use: new_table_cars.xlsx

Steps

Open the data.
In the search bar write your prompt and press enter.
On the left side of the input field, click the pencil to open the code snippet, see Figure below. This is the code that has been generated for your prompt.
Modify the code to your liking and then press run.

Image title — Here we see how the prompt is turned in to SQL code. The AVG function is used to calculate the average for each Manufacturer.

Result

Image title — We can modify the SQL code ourselves to return the sum, i.e. total value sold per car instead.

Well done! Now let's move on to the next mission!