1. 학습
  2. /
  3. 강의
  4. /
  5. PostgreSQL Summary Stats and Window Functions

Connected

연습 문제

Reigning weightlifting champions

A reigning champion is a champion who's won both the previous and current years' competitions. To determine if a champion is reigning, the previous and current years' results need to be in the same row, in two different columns.

지침 1/2

undefined XP
    1
    2
  • Return each year's gold medalists in the Men's 69KG weightlifting competition.