This time, we're traveling between cities in Germany. We'll use two tables:
german_city which contains the
road, which contains the columns
In this query, we won't be using GPS coordinates to calculate the distance; we'll use the
time column instead. It contains the average trip duration from one city to another, on a given route.
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 – City names, separated by
last_id – The ID of the last city.
total_time – The total time spent driving.
count_places – The number of places visited, which should equal 4.