Database nested queries, Display the book title and the

Database nested queries

Assignment Help Data Structure & Algorithms

Reference no: EM13764616

DATABASE NESTED QUERIES

1) Display the book title and the number of books sold where the profit from the book is more the 70%. The resulting list should display highest quantity of books title sold first in the list. Profit for a book is calculated as (retail - cost) / cost.

2) Display the publisher name, category and average price for books which belong to the either a category of ‘COMPUTER' or "CHILDREN' and where the average retail cost for the category is more than 50 dollars. Rename the calculated field ‘AVERAGE_CAT_PRICE' and format with a leading ‘

symbol and rounded to two decimal places.

3) Display the categories and the count of number of books in those categories where the category has the most books then the minimum number of books for all the categories. Sort the resulting set in category order ascending.

4) Display book title, ISBN number and cost for all books which belong to the category with the least number of books in the category. Format the cost field as dollars ‘ with two decimal places. Rename the new formatted cost field to ‘COST' (complex query)

5) Display all the categories and the total amount of profit for each category. Rename the calculated field as ‘CATEGORY_PROFIT'. Category profit is calculated as number of books sold times profit (retail - cost) in that category. Round the profit calculation to the nearest full value. Order the result set in the descending order of highest calculated profit.

Reference no: EM13764616

Questions Cloud

Compare different software development methods : Define and explain, in your own words, the primary challenge(s) of software development projects. Compare and contrast at least three (3) different software development methods.

Identify the types of stress unique to law enforcement : Identify the types of stress unique to law enforcement. What are some of the psychological reactions possibly caused by stress

How might it apply the law differently to the facts of case : The court ruled that remaining for 2 years was a "condition precedent" necessary for them to receive the $15,000 payment. What do you think? Is this a fair result? If the court wanted to find in favor of the employees, how might it apply the law..

Traditional methods for evaluating the capital investments : Suggest a methodology to supplement the traditional methods for evaluating the capital investments of Johnson Controls in the emerging markets to reduce risk providing a rationale of how risk will be reduced.

Database nested queries : Display the book title and the number of books sold where the profit from the book is more the 70%. The resulting list should display highest quantity of books title sold first in the list. Profit for a book is calculated as (retail - cost) / c..

Biotechnology applications issues : Provide at least three real-world examples of current or future applications of biotechnology in either of these fields. Present a minimum of three reliable references.

Assignment- fourth fifth and sixth amendment rights : Assignment: Fourth, Fifth and Sixth Amendment Rights, The Fourth Amendment to the U.S. Constitution protects citizens against police officers making unreasonable searches and seizures of personal property

Evaluate the strategy that led to the merger or acquisition : Merged with another company, or been acquired by another company, evaluate the strategy that led to the merger or acquisition to determine whether or not this merger or acquisition was a wise choice. Justify your opinion.

Chart of accounts of moore : Mr. Moore has hired you as his accountant. The two of you discuss the business and decide upon the following chart of accounts.

User Account

All Pages