Discuss the below:
Q: Create a query to produce the output shown in the figure (attachment). The output, derived from the CHARTER and MODEL tables, is limited to February 6, 2004. (Hint: The JOIN passes through another table. Note that the "connection" between CHARTER and MODEL requires the existence of AIRCRAFT, because the CHARTER table does not contain a foreign key to MODEL. However, CHARTER does contain AC_NUMBER, a foreign key to AIRCRAFT, which contains a foreign key to MODEL).
Refer to https://www.google.com/search?hl=en&q=chapter+7+introduction+to+structured+query+language.
Attachment:- Database structure.rar