Create a query to produce the output shown in the table below. Note that, in this case, the computed attribute requires data found in two different tables. (Hint: The MODEL table contains the charge per mile, and the CHARTER table contains the total miles flown.) Note also that the output is limited to charter records generated since 12 May, 2019. In addition, the output is ordered by date and, within the date, by the customer’s last name.
TABLE 2.5: PART B QUERY RESULTS
Due Date: Submit your responses to the Reflection, Provocative Question, Assignments and Assessments by 12pm WAT, on Friday after each module.