Querying ClimateDB

Now that you're connected to ClimateDB, it's time to write your first query!

Your First Query

Let's start by looking at the monthly atmospheric CO2 concentration levels. You can copy and run the query below:

select date, average
from climate.co2_monthly_concentration
order by 1 asc

Results

You should see the result set:

Now let's plot our data:

You've just queried 60 years of atmospheric CO2 concentration in 3 lines of SQL!