Tad Trips Database: Look at Link for data File: https://gofile.io/d/irik REATE TABLE taxi trips tzip_id bigez1 PRIMARY KEY, vendoz id varchar(1) NOT NULL, Sper_pickup_datetims timestamp with time zone NOT NULL, sper.dropoff_datetime timestz with time sone MOT NULL, Pangscount integer MOT NULL, trip distance mneric (8,2) NOT NULL, pickup longitude mameric(18, 15) NOT NULL, pickup latituds mmeric(18,15) MOT NULL, zate code id varchar(2) NOT NULL, tors, and fvd flag varchar(1) NOT NULL, dropof longitude mmeric(18,15) NOT NULL, dzopof latitude mmeric(18, 15) NOT NULL, Bayment typs vachar (1) NOT NULL, fans_amount mimeric (9,2) NOT NULL, extra mmeric(9,2) NOT NULL, ta tax mmeric(5,2) NOT NULL, tip amount mmeric(9, 2) NOT NULL, tolla amount numeric(9,2) NOT NULL, improvement_urchargs mmeric(9,2) NOT NULL, total amount numeric(9,2) NOT NULL Instruction for Expert: See Eile above, copy the link and put on browser, and hit download information to get data: Question 4. Revenues by vendor by rate code Find the sum of base fares (fare mount) by rate.code, id for each vendor. Order by vendor id ascending and total (gross) revenues descending (Columns should be vendor, Eate code, gross reveme) Your query should return the following: vendormid rate code is total revenue: 1 1 1 2 2 2 2 (7 ROWS) 11 | 2 I 5 11 12 1 1 1 1 1 5747.00 780.00 77.02 7060.50 1040.00 583.59 90.50 15 Question #5 Trips with higher than average fare amounts Return on the information from trips that rod o hoher than wroge tore amount Order by fare amount descending Your answer should look this trayendera pe pickup_datetime teperepoffidet pa 9 384 012 29 2010. 04.03.2018. 09: 44100 2010 0443.00 2016 d.o. 2016 ou 04.02.10 2016.01 044549:00 2010-04 14.00 10.01 2200 04 0.01 0 104 12.000 1400 01 04:02.00 10.00 04. edo 4es. 14.00.00.0044 do 16.00 do 2500 2010 4 2 46.000 4000 440 41 41 AN KS)