SQL Join and select

Vote count:

0

I am very new to SQL and I'm attempting to work through some exercises and I am having some trouble with the following problem:

There is a database consisting of six tables:

1. 
   

   Author(AUTHOR ID, AUTHOR NAME, AUTHOR FIRSTNAME)

   
   


2. 
   

   Book(BOOK ID, ISBN, TITLE, EDITOR, EDITION DATE) which contains the list of books (ISBN attribute is the key).

   
   


3. 
   

   Written(AUTHOR ID, BOOK ID) which is the list of books written by each author.

   
   


4. 
   

   Copy(BOOK ID, COPY ID, STATUS, ACQ DATE) which contains the list of copies for each book.

   
   


5. 
   

   Borrower(USER ID, USER NAME, USER FIRSTNAME, USER ADDRESS) which contains the list of borrowers.

   
   


6. 
   

   Borrowing(BOOK ID, COPY ID, USER ID, BORROWING DATE) which contains the list of borrowing in the library.

   
   

With these tables I am trying to accomplish a few queries:

1. 
   

   Search the titles of books written by Ernest Hemingway

   
   


2. 
   

   Search the id, name and first name of borrowers which borrow the book with id 10

   
   


3. 
   

   Search the number currently borrowing.

   
   


4. 
   

   Then for each book, search the id, title and number of copies which have the status borrowed

   
   

For the first one I used: SELECT title FROM Book WHERE Author='Ernest Hemingway

For the thrid: SELECT COUNT(DISTINCT book id) FROM Borrowing

I'm a little stumped on the remaining two (I'm a little confused on the join method) and I wanted to make sure these other two queries were correct as well. Any help is much appreciated.

Thanks guys!

asked 13 secs ago

jdv12

8

SQL Join and select