Midterm SQL: 3

The set of pairs (a, n), where n is the number of times
that Alon Levy has borrowed a book authored by a.

Select count(book_ISBN), author

From Borrowed, Book, Library_Patron

Where Borrowed.book_ISBN = Book.ISBN

And Library_Patron.first_name = ‘Alon’

And Library_Patron.last_name = ‘Levy’

And Borrowed.borrowers_card_number =

Library_Patron.card_number

Group by author

Previous slide

Next slide

Back to first slide

View graphic version