Interview Query

Crossing Bridges

4
Have you seen this question before?

Let’s say we want to run some data collection on the Golden Gate bridge.

  1. What would the table schema look like if we wanted to track how long each car took coming into San Francisco to enter and exit the bridge? Let’s say we want to track additional descriptives like the car model and license plate.

  2. Write a query on the given tables to get the time of the fastest car on the current day.

  3. Write a query on the given tables to get the car model with the average fastest times for the current day.

Example: Let’s say three Ferraris crossed the bridge in an average of one minute.

Next question: Three Zebras
.....
Loading comments