Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
2. Table route
PARTITION BY
Summary

Instruction

Alright, let's move on. Table number two: route.

Exercise

Select all the information from the table route.

A route in our system is, in other words, a railroad connection between point A and B.

Each route has its own id, its friendly name, the from_city and the to_city, as well as the distance between these two cities in kilometers.

For simplicity, we assume that we only have intercity trains, i.e. there are no stations between from_city and to_city where the train could stop.