Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Taxi SQL challenge!!! IMPORTANT ! ! ! Please provide exact answer in the format as it's asked, no extra details, as that would break automatic
Taxi SQL challenge!!! IMPORTANT Please provide exact answer in the format as it's asked, no extra details, as that would break automatic gradingTry to copy it from your query outputPlease do check the schemastructures for tables created. If it would be similar to below in PGAdmin find table, right click on it ScriptsCreate Script would reveal exact columns definitions then make sure to addquotesas part of the column name and useExAcT CaSefor affected column, egSELECTVendorID fromyellowtaxitrips;otherwise you'd get error that column is not found.CREATE TABLE IF NOT EXISTS public.yellowtaxidata "VendorID" integer, tpeppickupdatetime timestamp without time zone, tpepdropoffdatetime timestamp without time zone, passengercount bigint, tripdistance double precision, "RatecodeID" bigint, storeandfwdflag text COLLATE pgcatalog."default", "PULocationID" integer, "DOLocationID" integer, paymenttype bigint, fareamount double precision, extra double precision, mtatax double precision, tipamount double precision, tollsamount double precision, improvementsurcharge double precision, totalamount double precision, congestionsurcharge double precision, "Airportfee" double precisionCREATE TABLE IF NOT EXISTS public.zones index bigint, "LocationID" bigint, "Borough" text COLLATE pgcatalog."default", "Zone" text COLLATE pgcatalog."default", servicezone text COLLATE pgcatalog."default"How many taxi trips were there on March Consider only trips that started on March : Enter only final numberFind the largest tip for each day. On which day it was the largest tip in March? Use the pick up time for your calculations.: Please enter the final date egWhat was the most popular destination for passengers picked up in central park on March Use the pick up time for your calculations.: Enter the zone name not id If the zone name is unknown missing write "UnknownWhat's the pickupdropoff pair with the largest average price for a ride calculated based ontotalamount Enter two zone names separated by a slashFor example: Jamaica BayClinton East : If any of the zone names are unknown missing write "Unknown". For example: UnknownClinton EastPlease copy andpaste your SQL queries here. Remember: no code no scores
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started