10.Write a query to display the subject and the number of books in each subject. Sort the results by the number of books in descending order and then by subject name in ascending order

Assuming that the subject and book information is stored in two different tables, the query to display the subject and the number of books in each subject can be written as:

SELECT subject.name AS subject_name, COUNT(book.id) AS num_books
FROM subject
INNER JOIN book ON subject.id = book.subject_id
GROUP BY subject.name
ORDER BY num_books DESC, subject_name ASC;

This query uses an inner join to combine the information from the subject and book tables. It then uses the COUNT function to count the number of books in each subject, and the GROUP BY clause to group the results by subject name. Finally, the ORDER BY clause is used to sort the results first by the number of books in descending order and then by subject name in ascending order.