Subject wise book list

Posted by SANGAMESH, JAMKHANDI on
URL: http://ngl.70.s1.nabble.com/Subject-wise-book-list-tp7573468.html

how to find subject wise total books in copies, what is sql query pls tell me, sir, there is coming in detail but we need only number of total count, like Physics as subject, books 5601 or more