Homework 1: Docker, SQL and Terraform

1. What's the version of pip in the python:3.13 image? (1 point)

2. Given the docker-compose.yaml, what's the hostname and port that pgadmin should use to connect to the postgres database? (1 point)

3. For the trips in November 2025, how many trips had a trip_distance of less than or equal to 1 mile? (1 point)

4. Which was the pick up day with the longest trip distance? Only consider trips with trip_distance less than 100 miles. (1 point)

5. Which was the pickup zone with the largest total_amount (sum of all trips) on November 18th, 2025? (1 point)

6. For the passengers picked up in the zone named "East Harlem North" in November 2025, which was the drop off zone that had the largest tip? (1 point)

7. Which of the following sequences describes the workflow for: 1) Downloading provider plugins and setting up backend, 2) Generating proposed changes and auto-executing the plan, 3) Remove all resources managed by terraform? (1 point)