1. 学习
    2. /
  2. 课程
    3. /
  3. 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.