Given the following description                                                                                                                                                                                                                                                                        
 Your application, should handle the following:
• School operating the library. For each school, the following details should be registered: School name,
Address, City, Phone number, Email, Full name of the School Director, Full name of the responsible
School Library Operator. Each school unit (through the School Library Operator) is responsible for
registering the school’s library available books in the system.
• Books with their respective data (title, publisher, ISBN1
, authors, number of pages, summary, available
copies/ inventory, image, thematic category, language, keywords). Each book has one or more
authors and belongs to one or more categories.
• Application Users: For each user, the system must verify their identity when accessing the application
(via username/password) and each user can change his own password.
o Network School Library Administrator (Administrator): Registers Schools and
approves/appoints School Library Operators. They can create a backup copy of the entire
database and restore the system from it.
o School Library Operator. Operators are responsible for the operation of the School Library at
the school unit level. Operators have the ability to process all the information of the books
included in the system and to add new ones. They also supervise reservations and loans,
either collectively or by searching by user. (Delayed returns are displayed separately). They
can record the return of a borrowed title. They can record the loan of a copy when there is a
reservation for that particular title, provided that the user's loan limits are met and that no
returns are delayed. They also record loans without reservations, by searching for the user
and title, if the user meets the loan criteria mentioned above and if there are available copies.
o All school students, as well as the professors, can register and use the system. Approval from
Operator is required for registration. After approving each user, the Operator prints out the
borrower's card and delivers it to the user. Additionally, the Operator is authorized to delete
or disable user accounts in accordance with the library's policy. Educators have the ability to  modify their personal information, while students are only able to view it.                                                                                                                                               
 • Book borrowing: Each user of the system, at the level of the school unit, can view available books,
evaluate them and request to borrow a copy. Each student user can borrow up to two books per week,
while professors can borrow one per week. Borrowing/returning of books is handled by the Operator.
In case a copy of the book is not available, the user's request (reservation) is put on hold and is served
upon the return of a copy.
• Reservations: Regarding reservations, the borrowing limits apply, e.g., two reservations per week for
students. A reservation cannot be made if a book has not been returned on time or if the same user
has already borrowed the title. Users have the option to cancel any current reservations. Additionally,
reservations have a time frame of one week and are automatically canceled once it expires.
• Reviews: Users can share their thoughts about a book in a written review and provide a rating using
the Likert2
scale. Reviews written by students will be published upon approval by the Operator.
In addition to inputting the aforementioned information, all users of the application must have the ability
to manage information, including a search mechanism and options for updating or deleting it (CRUD).    Can you  give me the syntax for the following queries in mysql                                                                                                                                                                                                                                                                                                                             
  .List with the total number of loans per school (Search criteria: year, calendar month, e.g.
January).
4.1.2.For a given book category (user-selected), which authors belong to it and which teachers
have borrowed books from that category in the last year?
4.1.3.Find young teachers (age < 40 years) who have borrowed the most books and the number
of books.                                                                                                                                                                                                                                                                                                                      
 Find authors whose books have not been borrowed.
4.1.5.Which operators have loaned the same number of books in a year with more than 20 loans?
4.1.6.Many books cover more than one category. Among field pairs (e.g., history and poetry) that
are common in books, find the top-3 pairs that appeared in borrowings.
4.1.7.Find all authors who have written at least 5 books less than the author with the most books.                                                                                                                                            All books by Title, Author (Search criteria: title/ category/ author/ copies).
4.2.2.Find all borrowers who own at least one book and have delayed its return. (Search criteria:
First Name, Last Name, Delay Days).                                                                                                                                                                                                                                                                     Find Average Ratings per borrower and category (Search criteria: user/category)                                                                                                                                                                        4.3.1.List with all books (Search criteria: title/category/author), ability to select a book and create
a reservation request.
4.3.2.List of all books borrowed by this user.

        


modify their personal information, while students are only able to view it.