1. Learn
    2. /
  2. Courses
    3. /
  3. Time Series Analysis in PostgreSQL

Exercise

Next station

Wielding window functions effectively is like having a superpower. You can achieve results much faster.

In this exercise, you will use window functions to provide additional information for passengers aboard a train. In particular, you will use the train_schedule table to also provide the name of the next station, a common form of information that gives commuters time to prepare for the next stop.

Instructions

100 XP
  • Create a new field next_station that gives the name of the next stop for each stop on the train line.