We have some new tables! The first,
GermanCity, contains two columns,
Name. This time, we're travelling between cities in Germany and we won't be calculating the distance using a GPS function. Instead, we've been given a second table called
Road that has the columns
Time. It also comes with average trip durations on a given route from one city to another.
Let's travel between the four cities, starting in Berlin. Your task is to list the travel paths starting in Berlin and covering all four cities. Order the paths in descending order by
In your answer, provide the following columns:
Path – the city names, separated by
LastId – the ID of the last city visited,
TotalTime – the total time spent driving,
CountPlaces – the number of places visited; it should equal 4.