Question: FOR SQL with the following data: CREATE TABLE books ( books_id INT PRIMARY KEY AUTO_INCREMENT, title VARCHAR(1000), isbn VARCHAR(100), num_pages INT ); CREATE TABLE borrower

FOR SQL with the following data:

CREATE TABLE books (

books_id INT PRIMARY KEY AUTO_INCREMENT,

title VARCHAR(1000),

isbn VARCHAR(100),

num_pages INT

);

CREATE TABLE borrower (

borrower_id INT PRIMARY KEY AUTO_INCREMENT,

first_name VARCHAR(100),

last_name VARCHAR(100),

lib_card INT

);

INSERT INTO books VALUES (1,'The Way of Shadows','0-316-03367-7',688); INSERT INTO books VALUES (2,'The Parafaith War','0-8125-3894-3',480); INSERT INTO books VALUES (3,'The Book Thief','033036426X',584); INSERT INTO books VALUES (4,'Me Talk Pretty One Day','0-316-77772-2',288); INSERT INTO books VALUES (5,'Warbreaker','978-0-7653-2030-8',592); INSERT INTO books VALUES (6,NULL,'','');

INSERT INTO borrower VALUES (1,'Trisana','Chandler',1112223334); INSERT INTO borrower VALUES (2,'Shallan','Walker',9998887776); INSERT INTO borrower VALUES (3,'Annie','Wilkes',5554446660); INSERT INTO borrower VALUES (4,'','','');

Write a query to display the borrower name and title for all books checked out by the borrower who currently has the most books?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!