Write a SQL code that returns the name of aircraft (MOD_NAME in MODEL table), number of trips each mode flied (based on the CHARTER table, name this Trip_Num), and Total distance of each mode (based on the CHARTER table, name this Total_Distance). Table name: CHARTERCHAR_TRIP CHAR_DATE AC_NUMBER CHAR_DESTINATION CHAR_DISTANCE CHAR_HOURS_FLOWN CHAR_HOURS_WAIT CHAR_FUEL_GALLONS CHAR_OL_QTS CUS_CODE Table name: EARNEDRATING10001 05-Feb-16 228910002 05-Feb-16 2778V10003 05-Feb-16 4278Y10004 06-Feb-16 1484P10005 06-Feb-16 228910006 06-Feb-16 4278Y1000706-Feb-16 2778V07-Feb-16 1484P100081000907-Feb-16 2289L1001007-Feb-16 4278Y1001107-Feb-16 1484P10012 08-Feb-16 2778V08-Feb-16 4278Y100131001409-Feb-16 4278Y10015 09-Feb-16 2289L10016 09-Feb-16 2778V10017 10-Feb-16 1484P10018 10-Feb-16 4278YTable name: CREWCHAR_TRIP EMP NUM CREW JOB10001104 P10002101 P10003105 P100031000410005100061000710007100081000910010100111001110012100131001410015100151001610016100171001810018109 Copilot106 Pilot101 P109 Pilot104 P105 Cop106 Plot105 Pilot100 Plot101 P104 Cop101 Po105 P106 Pilot101 Cop104 P105 Cop109 P101 P104 Copilot105 PilotATLBNAGNVSTLATLSTLGNVTYSGNVATLBNAMOBTYSATLGNVMOYSTLTVS10010 Ramas10011 Dunne10012 SmithTable name: AIRCRAFTAC_NUMBER MOD_CODE AC TTAF1484PPA23-2502209LC-90A2778VPA31-3504278YPA31-35010013 Clowski10014 Orlando10015 O'Brian10016 Brown10017 Williams10018 Farriss10019 Smith106 Mrs.107 Mr.108 Mr.109 Ms.110 Mrs.AC_TTEL AC_TTER936320157447210234721574644157499035288464493616453125086441833.1 1833.14243.0768.9799292147.31513.1622.1AlfredLeonaKathyPaulMyronAmyJamesGeorgeAnneOlette101.81123.4789.5243.2AKWFBK5.11.6782.95.72679Table name: CUSTOMERCUS_CODE CUS_LNAME CUS_FNAME CUS_INITIAL CUS_AREACODE CUS_PHONE CUS_BALANCE844-2573894-1238894-2285Table name: EMPLOYEEEMP NUM EMP TITLE EMP LNAME EMP_FNAME EMP_INITIAL100 Mr.KolmyczLewis101 Ms.102 MrVandam103 Ms.Jones104 Mr.Lange105 Mr.WilliamsDuzakDianteWesenbachTravisGenkaziGeorgeRhondaRhettAnneJohnRobertJeanineJorgePaulElizabethLeighia6.66.21.93.96.16.7153.13.8615713615615615713615615713615D0MPDKDRKW2200Table name: PILOTEMP_NUM PIL LICENSE101 ATP104 ATP105 COM106 COM109 COM4.93.55.20023.43.25.3424.52.10004.5894-2180222-1672442-3381297-1228290-2556382-7185297-3809354.172618-Jun-196119-May-1970339.897.2117.1348.4140.6459.9279.766.41PL_RATINGSATP/SELMELAnstr/CFIATP/SELMELAnstrCOMM/SELMELA/CFCOMMISELMELAnstrATPISELMEL/SESAnstr/CF 1122215.1174.3302.6459.5672105.5167 A0.000.00896.541285.19673.211014.560.000.000.00453.98EMP DOB15-Jun-194219-Mar-196514-Nov-1958 20-Dec-199216-Oct-1974 28-Aug-200508-Nov-1971 20-Oct-199614-Mar-197512-Feb-196821-Aug-197414-Feb-196602-Ju-199618-Nov-1994114-Apr-199101-Dec-199202120210010108-Jan-2006 PA31-35005-Jan-199102000CFICFIINSTRMELSELSES1001110016 EMP_NUM RTG_CODE EARNRTO_DATE10014100191001110017100121001410017100161001210010100111001710016100111001410017EMP HIRE DATE15-Mar-198725-Apr-1988 Table name: MODELTable name: RATINGRTG_CODERTO NAMECertified Flight InstructorCertified Flight Instructor, InstrumentInstrumentMutiengine LandPIL_MED_TYPE PIL_MED_DATE PL_PT135_DATE20-Jan-1618-Dec-1505-Jan-1610-Dec-1522-Jan-16101 CFI101 CFI101 INSTR101 MEL101 SEL104 INSTR104 MEL104 SEL105 CFI105 INSTR105 MEL105 SEL106 INSTR106 MEL106 SEL109 CFI109 CFSingle Engine, LandSingle Engine, Sea109 INSTR109 MEL109 SEL109 SES11-Jan-1617-Jan-1602-Jan-1602-Feb-1615-Jan-16MOD_CODE MOD_MANUFACTURER MOD_NAME MOD_SEATS MOD_CHO_MILEC-90A BeechcraftPA23-250 PiperPiper18-Feb-9815-Dec-0506-Nov-9323-Jun-9421-Apr-9015-JM-9629-Jan-9712-Mar-9518-Nov-9717-Apr-9512-Aug-9523-Sep-94KingAirAztecNavajo Chieftain20-Dec-9502-Apr-9610-Mar-9405-Nov-9021-Jun-0323-4-9615-Mar-9705-Feb-9612-May-9686102.671.932.35

SQL queries are a set of instructions given to the database to retrieve specific data. SQL was invented by IBM. Commands used to retrieve data such as SELECT, UPDATE, DELETE, INSERT etc. Every command in SQL has a specific format to follow. By using databases with these SQL queries we can manage the data in a secured and structured way.The SQL query will be :SELECT MODEL.MOD_NAME, Count(CHARTER.AC_NUMBER) AS “Trip_Num”, Sum(CHARTER.CHAR_DISTANCE)AS “Total_Distance”FROM CHARTERJOIN AIRCRAFT ON AIRCRAFT.AC_NUMBER = CHARTER.AC_NUMBERJOIN MODEL ON MODEL.MOD_CODE = AIRCRAFT.MOD_CODE;Step 1The first step is to look at the schema and select the columns we want to show. MODEL.MOD_NAME, Count(CHARTER.AC_NUMBER) AS “Trip_Num” ,Sum(CHARTER.CHAR_DISTANCE)AS “Total_Distance”.It is crucial to list your columns using table names. You will not get confused by the various column names and will be able to tell which column belongs to which table as a result.SELECT MODEL.MOD_NAME, Count(CHARTER.AC_NUMBER) AS “Trip_Num”,Sum(CHARTER.CHAR_DISTANCE)AS “Total_Distance”Step 2The following step is to decide which tables the query will require. The two most prominent ones are MODEL and CHARTER. We will need to figure out how to combine these tables, though. We can tell that MODEL is a junction table between these two by looking at the database schema. Therefore, we also need that table.Step 3We must connect all the tables together in the last step. Selecting the table for the FROM clause is the first step. Starting with a table that is not a junction table is the first step. Let's use the CHARTER table in this instance.We are currently unable to join the course table. These two tables don't directly relate to one another. We'll have to use the student course table as a result. Simply use the JOIN... ON... expression to join these two tables together. As our code develops:SELECT MODEL.MOD_NAME, Count(CHARTER.AC_NUMBER) AS “Trip_Num”, Sum(CHARTER.CHAR_DISTANCE)AS “Total_Distance”FROM CHARTERJOIN AIRCRAFT ON AIRCRAFT.AC_NUMBER = CHARTER.AC_NUMBERConsider what we have accomplished so far before continuing to add the final table. Keep in mind that when crafting a JOIN clause, we have access to all the columns and are not just constrained to the ones in the SELECT clause! So, then, our question is as follows:SELECT MODEL.MOD_NAME, Count(CHARTER.AC_NUMBER) AS “Trip_Num”, Sum(CHARTER.CHAR_DISTANCE)AS “Total_Distance”FROM CHARTERJOIN AIRCRAFT ON AIRCRAFT.AC_NUMBER = CHARTER.AC_NUMBERJOIN MODEL ON MODEL.MOD_CODE = AIRCRAFT.MOD_CODE;Thus required query is given above with proper explanation.