Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.
Suppose you have the following table in a relational database:...
Suppose you have the following table in a relational database:
LoanIDLoanAmountOrigDateTypeOfLoanIntRateLoanedToPeriodsL0011000008/1/16House3George360L0022000009/10/16House3.25Lucas360L0034000010/1/16Car2.5Patrick36L0043000011/15/16Car3.2Nancy48L0052000012/1/16Car2.75Peter36
CustomerStreetAddressCityStatePhoneGeorge111 Main St.SarasotaFL123-4567Lukas222 High St.BradentonFL234-5678Patrick333 Local St.BrandonFL345-6789Nancy444 Univ. St.ParrishFL456-7890Peter555 Zigzag St.VeniceFL987-6543
How do I find an SQL statement to loanID, loan amount, OrigDate, IntRate, Customer name, customer phone for all loans given originating after August and before November, i.e. for September and October of 2016.
