Question: 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 add quotes as part of the column name and use ExAcT CaSe for affected column, eg SELECT "VendorID" from yellowtaxitrips;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 precision CREATE 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" Sofiya. How many taxi trips were there on March Consider only trips that started on March :
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
