TeTrips Database: Look at lank for data file: https://gofile.io/d/irik REATE TABLE taxi trips ( trip is bigerial PRIMARY KEY, vendor id varchar(1) NOT NULL, per_pickup_datetins timestamp with time sone MOT NULL, spep_dropoff dateting timestay with time cope NOT NULL, Pengse, count integer NOT NULL, trip. distanse mneric (8,2) NOT NULL, pickup longitude mmeric(18, 15) NOT NULL, pickup latituds mmeric(18,15) NOT NULL, zate code, id varchar(2) NOT NULL, tors, and fvd flag varchar(1) NOT NULL, dzopot longitude mmezic(18, 15) NOT NULL, dropof latitude mmeric(18, 15) NOT NULL, Payment Typs varchar(1) NOT NULL, Faze amount mimeric (9,2) NOT NULL, extra mmeric(9,2) NOT NULL, mata tax mmeric(5,2) NOT NULL, tip mount mmeric(9, 2) NOT NULL, tolls amount numeric(9,2) NOT NULL, improvement_uzcharge americ(9,2) NOT NULL, total amount numeric(9,2) NOT NULL Instruction for Experts See file above, copy the link and put on browser, and hit download information to get data: Return the average distance traveled per trip by each of the vendors in taxi.tripa. Round your answers to 2 decimal. Order by vendorwid. I Your query should return: vendor id | round 1 2 (2 rows) 1 1 3.81 4.49 2. Average Cost/Rider for Multi-Rider trips Calculate the average cost per rider for all trips where there was more than 1 rider. Round the answer to 2 decimal places (the Enswer is one average for all riders on these trip:) Your query should return the following: avg. sort 6.90 (1 LOW) 3. Highest Tip by rate code Find the highest tip percentage (use fare mount AS denominator) for each date code, order by wate..code. Retum gatsusede, id and the percentage rounded to two decimal points. Your query should return the following: Fatecedswid max.P.Psesentage 1 2 4 5 (4 LOW) 75.00 28.04 0.00 20. 1B TeTrips Database: Look at lank for data file: https://gofile.io/d/irik REATE TABLE taxi trips ( trip is bigerial PRIMARY KEY, vendor id varchar(1) NOT NULL, per_pickup_datetins timestamp with time sone MOT NULL, spep_dropoff dateting timestay with time cope NOT NULL, Pengse, count integer NOT NULL, trip. distanse mneric (8,2) NOT NULL, pickup longitude mmeric(18, 15) NOT NULL, pickup latituds mmeric(18,15) NOT NULL, zate code, id varchar(2) NOT NULL, tors, and fvd flag varchar(1) NOT NULL, dzopot longitude mmezic(18, 15) NOT NULL, dropof latitude mmeric(18, 15) NOT NULL, Payment Typs varchar(1) NOT NULL, Faze amount mimeric (9,2) NOT NULL, extra mmeric(9,2) NOT NULL, mata tax mmeric(5,2) NOT NULL, tip mount mmeric(9, 2) NOT NULL, tolls amount numeric(9,2) NOT NULL, improvement_uzcharge americ(9,2) NOT NULL, total amount numeric(9,2) NOT NULL Instruction for Experts See file above, copy the link and put on browser, and hit download information to get data: Return the average distance traveled per trip by each of the vendors in taxi.tripa. Round your answers to 2 decimal. Order by vendorwid. I Your query should return: vendor id | round 1 2 (2 rows) 1 1 3.81 4.49 2. Average Cost/Rider for Multi-Rider trips Calculate the average cost per rider for all trips where there was more than 1 rider. Round the answer to 2 decimal places (the Enswer is one average for all riders on these trip:) Your query should return the following: avg. sort 6.90 (1 LOW) 3. Highest Tip by rate code Find the highest tip percentage (use fare mount AS denominator) for each date code, order by wate..code. Retum gatsusede, id and the percentage rounded to two decimal points. Your query should return the following: Fatecedswid max.P.Psesentage 1 2 4 5 (4 LOW) 75.00 28.04 0.00 20. 1B