How many copies per title + author are there in my library?

This view displays TITLE, AUTHOR, and NUMBER OF COPIES.

Copy the text from the above box. Paste the text into the custom view box. Click Save to save the view.

How many copies per title are there in my library?

Listing Items with Multiple Copies
When additional copies of a book are entered in the library's copy section, that data is recorded in the LIB_COPIES table. A view can be created to list items with multiple copies, helping track inventory levels and inform purchasing decisions.

This view displays TITLE and NUMBER OF COPIES.

Copy the text from the above box. Paste the text into the custom view box. Click Save to save the view.

How many copies per title are there in my library?

Additionally, a more refined view can be defined to list items with a specific range of copies, such as those with more than 14 but fewer than 21 copies.

Copy the text from the above box. Paste the text into the custom view box. Click Save to save the view.

Question: How to display items with the same title?

Question: Is this specific SQL language? My question is how can I design and run reports including and using the Count(*) element, to include number of copies. I'd like to include data in addition to Title and Count in the statistics report. Volunteer Librarian

Question: Could you show me where to find information on what and how the SQL definitions under Statistics, Custom View Assistant work, specifically the "copies per title" sort process? Cannot find anything in the online support pages.

Question: Under the statistics tab, there are a selection of reports available including Copies Per Title. This report appears to list the actual number of copies of each book by title in the library.

Answer: To define query with grouping and more data fields in separate columns you have to group by all those fields. Example:
SELECT B.TITLE, B.AUTHOR, B.PUBLISHER, COUNT(*) FROM LIB_COPIES A JOIN LIBRARY B ON A.IDNO=B.IDNO GROUP BY B.TITLE, B.AUTHOR, B.PUBLISHER ORDER BY B.TITLE

Answer: Our library system is using Firebird SQL.