Query of remaining bibliography (2)

InQuery of remaining bibliography (1)

In the book table, only the title is required. In practice, it is not enough to provide only the title of a book, but also the publishing house information. Therefore, the book table is improved to (books are added ):

Now, you need to list all titles and the number of remaining titles.

The SQL statement is as follows:

Select title,
Publisher, count (ID)-count (userid) as remain
From (book left join borrow on book. ID = borrow. bookid)
Group by title, publisher
;

Query results:

Note: The preceding SQL statement uses group by with two attributes. That is to say, the set of attributes (title and publisher) of the connection result is divided into one group, and the count (ID) is calculated for each group) -Count (userid ).