831 views
0 votes
0 votes
Consider the library database.Write the following queries in
SQL.
a. Print the names of members who have borrowed any book published
by “McGraw-Hill”.
b. Print the names of members who have borrowed all books published
by “McGraw-Hill”.
c. For each publisher, print the names of members who have borrowed
more than five books of that publisher.
d. Print the average number of books borrowed per member. Take into
account that if an member does not borrow any books, then that
member does not appear in the borrowed relation at all.

member(memb no, name, age)
book(isbn, title, authors, publisher)
borrowed(memb no, isbn, date)

Please log in or register to answer this question.

Related questions

0 votes
0 votes
1 answer
1
ajaysoni1924 asked Mar 30, 2019
714 views
Rewrite the where clausewhere unique (select title from course)without using the unique construct.
0 votes
0 votes
0 answers
3
0 votes
0 votes
1 answer
4