Get startedGet started for free

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.

This exercise is part of the course

Time Series Analysis in PostgreSQL

View Course

Exercise instructions

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

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

-- Give the name of the station for the next stop
SELECT
  train_id,
  station,
  ___ ___ (
	PARTITION BY ___
	ORDER BY ___) AS next_station
FROM train_schedule
ORDER BY train_id, arrival_time;
Edit and Run Code