The Driver Relationship team wants to work with the active drivers using a VIEW constructed on the DRIVERS table. By creating the VIEW the team wants to eliminate extra work to keep both tables up-to-date. Create a VIEW for the drivers that has at least one travel in InstantStay.Task Create the ACTIVE_DRIVERS VIEW for working with active drivers. In the USERS table, information for the users are stored with their first name, last name andemail:USER IDUSER LAST NAMEUSER EMAILUSER FIRST NAME3001JackHillLhillexmal.com3002RyanCollinsr.collins@xmail.com3003NursinYilmazn.atak@gmail.com3004SarahPrices.price@xmail.com3005BobbyGriffinbgriffinexmail.com3006RandyClarkr.clark@xmail.com3007JoseThomasj,thomas@xmail.com3008NursinYillmazn.yilmaz@xmal.comUSERS TableIn the DRIVERS table, all the drivers in the InstantRide are stored with their name, drivinglicense number and check and rating information:DRIVER ID DRIVER FIRST_NAME DRIVER LAST NAME DRIVER DRIVING LICENSE ID DRIVER START DATE DRIVER DRIVING LICENSE CHECKED DRIVER RATING2001willieButler18745012019-09-124.42002JustinHoward19538532019-09-094.82003AnthonyWalker17354872019-09-153.52004EceYilmaz17347472019-08-15DRIVERS TableIn the CARS table, all the cars in the InstantRide system are kept with the license plate, modeland year:CAR IDCAR PLATECAR MODELCAR YEAR1001BB-542-ABTOYOTA PRIUS20181002BB-883-EETESLA MODEL 320191003BB-451-ZNTOYOTA AURIS20191004BB-189-MMMERCEDES E2002019 TRAVEL DTRAVEL START TIMETRAVEL END TIMETRAVEL START LOCATIONTRAVEL END LOCATIONDRIVER IDCAR DUSER OTRAVEL DISCOUNTTRAVEL PRICE2010.10ar De:1:19A Vork EnardMChuren Lane16.4420012013-1001 :1as47 Chure Sengheer200120.ENULL20 n0 1R 0201104 13:t:10WineearWet r13.32000100201-140s0 MII ane7 M teat200n201104 16::1011,15200120 0 114reanwy2013-1001 11:21tso Min nat200n206 160632019-100 16543 Dan Anod91 West or441200010043008014201510-03 17 17122019-10-03 17:37h4237 The Drive17 Staniey Roed25.12200110033000.252015-10-03 216s2019-10-03 2127 MII Road724 Sprngte Rad13.5520013005NULL201510-03 2321402019-1003 23:391o16 Church oad30 North Road25.62200010023003020TRAVELS Table

Explanation: “View” command is sued to view the data in table like structure and it is considered as result-set. The view command hold the real table attributes to show the virtual table. The below statement shows the syntax of “View”. CREATE VIEW view_name AS SELECT column_name1, column_name2…column_namen FROM table_name WHERE condition;Query: Here, the condition to create view is “InstantStay>=1”. The following query is used create a view for ACTIVE_DRIVERS. //Creating view CREATE VIEW [activeDriversView] AS SELECT * FROM ACTIVE_DRIVERS WHERE InstantStay >=1; //To view the result of “view” command SELECT * FROM [activeDriversView];