I am looking for help writing the following SQL queriesDisplay the names of the books sold by the bookstore which were published by a publisher from New York. List each book name only once. State it as a subquery. Display the names of the books purchased by customer number 65378. Use a join to answer the question. Display the names of the books purchased by customer number 65378. Use a subquery to answer the question. List the names of all books which have fewer pages than the average number of pages in all books published by Lions Publishing. List the names of all books which have fewer pages than the number of pages in every book published by Lions Publishing. List the names of all books which have fewer pages than the number of pages in at least one book published by Lions Publishing. List all customer information for the customer or customers who paid the least for any book in the store.List all book information for the book or books which sold for the average price of all books sold by the store. The image presents a relational database schema diagram featuring four main entities: BOOK, CUSTOMER, SALES, and PUBLISHER. Each entity is represented by a table containing various attributes, with arrows indicating relationships between them.### BOOK- **Attributes**: - **BOOKNUM**: Identifier for the book. - **BOOKNAME**: Name of the book. - **PUBYEAR**: Year the book was published. - **PAGES**: Number of pages in the book. - **PUBNAME**: Publisher's name.### CUSTOMER- **Attributes**: - **CUSTNUM**: Identifier for the customer. - **CUSTNAME**: Name of the customer. - **ADDRESS**: Customer's address. - **PHONE**: Customer's phone number.### SALES- **Attributes**: - **BOOKNUM**: Identifier for the book sold. - **CUSTNUM**: Identifier for the customer who bought the book. - **DATE**: Date of the sale. - **PRICE**: Price of the book at the time of sale.### PUBLISHER- **Attributes**: - **PUBNAME**: Name of the publisher. - **ADDRESS**: Publisher's address. - **PHONE**: Publisher's phone number.### Relationships- **BOOK to CUSTOMER**: Arrows indicate a relationship where a customer can purchase one or more books.- **SALES**: Connects BOOKNUM and CUSTNUM, indicating a transactional relationship between books and customers.- **BOOK to PUBLISHER**: A direct link from BOOK to PUBLISHER using the PUBNAME attribute, showing who published the book.### TaskThe task provided in the image is to write SQL queries to retrieve information based on this schema. This involves creating queries to extract details such as book sales, customer purchases, and publisher information, which can be documented in a Word document or similar format.

As per our guidelines, we are supposed to answer only 1st three parts. Kindly repost the remaining…

Answered: Display the names of the books sold by…

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

Related questions

Question

I am looking for help writing the following SQL queries

Display the names of the books sold by the bookstore which were published by a publisher from New York. List each book name only once. State it as a subquery.

Display the names of the books purchased by customer number 65378. Use a join to answer the question.

Display the names of the books purchased by customer number 65378. Use a subquery to answer the question.

List the names of all books which have fewer pages than the average number of pages in all books published by Lions Publishing.

List the names of all books which have fewer pages than the number of pages in every book published by Lions Publishing.

List the names of all books which have fewer pages than the number of pages in at least one book published by Lions Publishing.

List all customer information for the customer or customers who paid the least for any book in the store.
List all book information for the book or books which sold for the average price of all books sold by the store.