Hello, I would like an answer to this question immediately, thank you.

Question:

AUTHOR (authorID, FirstName, LastName, studyField)

PUBLISHER (pubID, pubName, pubCity, pubContactNo)

BOOK (bookID, bkTitle, bkPrice, bkEdition, bkPublishdate, bkPublisherID)

BOOKWRITERS (bookID, authorID)

Note:

Study field means like computer science, databases, networks, software engineering, etc.

In book table, the field bkPublisherID is a foreign key referencing to pubID (primary key) in publisher table.

Write SQL queries to answer the following.

3.1 Find the title of books written by William Stalling in the field of computer networks.

3.2 Find the list of authors who has not written any book yet.

3.3 Find the number of books published by each publisher.

3.4 Find the list of publishers whether they have published any book or not.

3.5 Find the title, price and publishers name of the most expensive book published so far.