1. Learn
    2. /
  2. Courses
    3. /
  3. PostgreSQL Summary Stats and Window Functions

Exercise

A basic pivot

You have the following table of Pole Vault gold medalist countries by gender in 2008 and 2012.

| Gender | Year | Country |
|--------|------|---------|
| Men    | 2008 | AUS     |
| Men    | 2012 | FRA     |
| Women  | 2008 | RUS     |
| Women  | 2012 | USA     |

Pivot it by Year to get the following reshaped, cleaner table.

| Gender | 2008 | 2012 |
|--------|------|------|
| Men    | AUS  | FRA  |
| Women  | RUS  | USA  |

Instructions

100 XP
  • Create the correct extension.
  • Fill in the column names of the pivoted table.