Question: Using the ERD in section, Problem 1A, write SQL statements for the following: a) Retrieve all books information that start with C in its ISBN.


Street City Postcode No of conies PP Address ISBN BID Name Title Borrower Book Borrowed Book Return Date Row Date Orace werden CUSTOMER ORDER OwOndernemer arder les Os sebeplede ORDER LINE PRODUCT Problem 2. (10 Marks) Using the ERD in section, Problem 1A, write SQL statements for the following: a) Retrieve all books information that start with "C" in its ISBN. b) Retrieve all book titles and book ISBNs that have more than 5 copies. c) Retrieve all borrowers' information that lives in Cairo. d) Retrieve all Books information
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
