Introduction
3. The Journey table
PARTITION BY
Summary

Instruction

Good. Two more tables to go!

Exercise

Select all the information from the Journey table.

A journey is what passengers can buy tickets for. Each journey has its own ID, an assigned train, a set route, and a set day.

Take a look at the first row: if you had wanted to go from Sheffield to Manchester with train 1 on 3 Jan 2016, you would have bought a ticket for the journey with the ID of 1.