SQL
Worth 3% of the total marks 1. List in ascending order the Last Names of all borrowers with Card Number less than 150. 2. What are the records of those loans between 3 June 2014 and 8 Mar 2018? ◦ The output should include the name of the cardholder, and title of the book ◦ List in ascending order by last name and first name 3. Find the total numbers of loans with last name beginning with D through E (including E); include last name beginning with Q as well as Z also. 4. Find all borrowers for a loan that have the Date-in before 15-March-15 and the Card number between 100 and 300 in Karama or Darwin. 5. Find the number of loans, which have been made from each branch? ◦ Note all branches need to be included even those with no loan
7 years ago 80
Answer(0)
other Questions(10)
- I need help with this
- 6531 WK 8 ASSIGN 1
- NO PLAGIARISM this work will be checked before i turn it in.. please read and follow direction
- Selected transactions for the Joel Berges Company are presented in journal form below. Date Account Titles and Explanation Ref. Debit Credit May 5 Accounts Receivable 4,628 Service Revenue 4,628 (Billed for services performed) 12 Cash 2,082
- ebusiness5
- Financial Management 1
- How do you intend to help accomplish Kappa Epsilon Psi Military Sorority's Mission of: Honoring our Past, Uniting our Present, and Mentoring our Future?
- finanance hw
- applied immunology
- Math project