Fuller & Ackerman Publishing is celebrating its 25th year in the marketplace. Management has decided to...

Transcribed Image Text:

Fuller & Ackerman Publishing is celebrating its 25th year in the marketplace. Management has decided to release a "golden oldies" collection of books published in the 1990s. The details of the old books are available in the "Obsolete_titles" table. The information required is a list of books that were released in the 1990s, the exact year they were released, and the age of each book. 2) Management wants to expand Fuller & Ackerman Publishing. They have decided that as part of their planning, they need to determine the amount invested in the titles published in the past and then estimate the investments they need to make for the growth of the company. They have decided to use the sales figures from the year 2013 for this analysis. In order to perform their analysis, management would like you to retrieve the following information: • The titles released in 2013. • A count of the titles released, the total development cost for all books, and the average development cost for a title. • A list of books for which the development cost is not defined. 3) Management has asked you to provide the following: After reviewing the performance of sales representatives, management decided to arrange a weekend trip to recognize their contribution. For booking tickets and fixing accommodations, management has asked you to provide a list of the names of representatives along with their representative IDs. • To show their appreciation for customers and to encourage them to purchase more titles, management decides to send a "thank you" note to the customers along with some gifts. You must prepare a list of customers' names and addresses. Fuller & Ackerman Publishing is celebrating its 25th year in the marketplace. Management has decided to release a "golden oldies" collection of books published in the 1990s. The details of the old books are available in the "Obsolete_titles" table. The information required is a list of books that were released in the 1990s, the exact year they were released, and the age of each book. 2) Management wants to expand Fuller & Ackerman Publishing. They have decided that as part of their planning, they need to determine the amount invested in the titles published in the past and then estimate the investments they need to make for the growth of the company. They have decided to use the sales figures from the year 2013 for this analysis. In order to perform their analysis, management would like you to retrieve the following information: • The titles released in 2013. • A count of the titles released, the total development cost for all books, and the average development cost for a title. • A list of books for which the development cost is not defined. 3) Management has asked you to provide the following: After reviewing the performance of sales representatives, management decided to arrange a weekend trip to recognize their contribution. For booking tickets and fixing accommodations, management has asked you to provide a list of the names of representatives along with their representative IDs. • To show their appreciation for customers and to encourage them to purchase more titles, management decides to send a "thank you" note to the customers along with some gifts. You must prepare a list of customers' names and addresses.

Answer rating: 100% (QA)

To retrieve the required information for each of the three tasks you mentioned youll need to use SQL ... View the full answer