There are two csv-files in the data
directory:
data/country-happiness.csv
: contains the happiness index for each countrydata/wine-price.csv
: contains wine pricing data
- Using the database engine of your choice, create two tables for both csv-files in the
data
directory and ingest the file contents.
-
What's the
max
,min
andaverage
happiness score? -
Show a table with the happiness rank and score of the G7 countries (i.e.,
Cananda
,France
,Germany
,Italy
,Japan
,United Kingdom
,United States
).
Note: Limit the output to 10 rows.
-
How many wines are register per
country
? -
What is the average wine
price
perprovince
?
-
What's the average wine-price of the countries with happiness
$score > 7.0$ ? -
Create a csv-file named
output.csv
that contains the country name, rank, score, min-price, average-price, and max-price. The table must be in increasing rank order.