data-engineering-zoomcamp/cohorts/2025/01-docker-terraform/homework.md at main · DataTalksClub/data-engineering-zoomcamp

docker run -it python:3.12.8
import pip
print(pip.__version__)

24.3.1

• 둘다 연결 성공함.
• 답은
  • postgres:5432
  • db:5432

SELECT
     DISTINCT COUNT(*) AS trip_count
 FROM
     green_taxi_data
 WHERE
     lpep_dropoff_datetime >= '2019-10-01' AND
     lpep_dropoff_datetime < '2019-11-01' AND
	 trip_distance <= 1;

• 104,802; 198,924; 109,603; 27,678; 35,189