Quiz 2 – Structured Query Language (SQL)- A Computer Language Used In Designing Databases. (Course Code: DBMS 101-M2)

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

 

CHAR_DATECUS_LNAMECHAR_DISTANCEMOD_CHG_MILEMileage Charge
12-May-19Babatunde1645.002.674392.15
12-May-19Abbe312.002.35733.20
12-May-19Mpho936.002.352199.60
13-May-19Okonmah508.001.93980.44
13-May-19Eze644.002.351513.40

 

Due Date: Submit your responses to the Reflection, Provocative Question, Assignments and Assessments by 12pm WAT, on Friday after each module.

Content | Menu | Access panel