HW
Question 1 :
select count(*) from trips_data_all.external_yellow_tripdata;
Question 2 :
select distinct(PULocationID) from trips_data_all.external_yellow_tripdata;
select distinct(PULocationID) from trips_data_all.yellow_tripdata_non_partitioned;
Question 4 :
select count(fare_amount) from trips_data_all.external_yellow_tripdata where fare_amount = 0;
Question 6 : select distinct VendorID from trips_data_all.yellow_tripdata_optimized where tpep_dropoff_datetime between "2024-03-01" and "2024-03-15";
select distinct VendorID from trips_data_all.yellow_tripdata_non_partitioned
where tpep_dropoff_datetime between "2024-03-01" and "2024-03-15";