Skip to content

Exploratory Data Analysis in SQL for Absolute Beginners

1 hidden cell

Query the table

  1. Query the full table
Spinner
DataFrameas
df
variable
SELECT *
FROM climate
  1. Query the country and water_stress_index fields and order by descending order of the water_stress_index field
Spinner
DataFrameas
df
variable
SELECT country, water_stress_index
FROM climate 
ORDER BY water_stress_index DESC;
  1. Query the country, year, and gdp_per_capita field to get a list of the country names and their respective GDP; order by the GDP in ascending order but only view the top 10 values
Spinner
DataFrameas
df
variable
SELECT country, year, gdp_per_capita
FROM climate 
ORDER BY gdp_per_capita ASC
LIMIT 10;

Filter the data

  1. Filter the data to see the country and year where the water_stress_index was between 0.5 and 0.6
Spinner
DataFrameas
df
variable
SELECT country, year, water_stress_index
FROM climate 
WHERE water_stress_index BETWEEN 0.5 AND 0.6;
  1. This time, filter the data to see the countries that start with the letter E or S and have a water_stress_index above 0.5
Spinner
DataFrameas
df
variable
SELECT country, water_stress_index
FROM climate 
WHERE water_stress_index > 0.5 AND (country LIKE 'S%' OR country LIKE 'E%');

Aggregate, group, and sort the data

‌
‌
‌