Question: imagine you are managing a database for a book store. the table book sales contains information about sales transaction.each row represents a sale including the

imagine you are managing a database for a book store. the table book sales contains information about sales transaction.each row represents a sale including the book title the quantity sold the sales date and the total revenue generated your task is to write a query that retrieves the books that have a total quantity sold greater than

50

and an average revenue for book greater than

15

the average revenue generated should be rounded to to decimal places output the results in descending order of average revenue per book

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

Imagine you are managing a database for a bookstore. The table book _ sales contains information about sales transactions. Each row represents a sale, including the book's title, the quantity sold,...

There are two problems due this week (each worth 35 points) as follows. Problem 1.6 (page 20) In comprehensive paragraphs, answerrequirements a to e. You will have 5 paragraphs total of four to five...

My name is Salam Abdulhussein and I need this to be done as soon as possible. Please follow the steps one by one and make sure everything is correct Global Bike, Inc. ERP for Sales / Collection USING...

our supervisor met with Mr. Z and discussed his requirements in detail. At that meeting, they agreed on the following deliverables for your project. Document process activity using BPMN. After...

The presentations, of work-in-progress on the major assignments, will occur during the tutorials in Weeks 8 and 9. The presentations are worth 5% of the total assignment. The presentations will be on...

Please make corrections to the draft of your final project. Your final project must include the following elements: 1. Background of Database: The requirement for automated inventory management and...

I need to create an executive level report on the internal management of Belk. Inc. My assignment is that I am looking to acquire Belk, What information and analysis do I need to have in this report?...

Chart Assignment: After reviewing Ch. 10 of aplia in the text, you will put your knowledge to work. You will be constructing charts based on the information below. You must use the information found...

REGIONAL REALTY ASSOCIATION AUTHOR DATE PURPOSE ANALYSIS CORA WILKE 1/23/2016 ANALYSIS OF THE CLAIM BY LUKE LIBERTY REALTY No they should not advertise that they your get your price. On the analysis...

Lab 1 - Books Galore - Saved to this PC Heb Help Acrobat Ptal me what you will no lonke Galerie - Saved to = 2 R Acrobat Tell me what you want to do TP Find bccc c AABBcco - - Reple 1 Heading 1 1...

(a) Find the gradient vector Vf (2, 3) where f(x, y) = x sin ry. (b) Find the directional derivative Duf at the point (x, y) = 1. u= (c) Find the maximum rate of increase of f at (2,4). [1] (2,) in...

Under the UCC Sales Article, which of the following conditions will prevent the formation of an enforceable sale of goods contract? Open price.Open delivery.Open quantityOpen acceptance.

15. The diagram shows a APQR. D lies on PQ, A lies on QR and C lies on PR. DR meets AC at B and AC is parallel to QP. AR = 4 cm, QA = 3 cm, DQ = 7 cm and 4 PD = 4 cm. Find (i) the length of BC, (ii)...

Claim: More than 3.5% of homes have only a landline telephone and no wireless phone. Sample data: A survey by the National Center for Health Statistics showed that among 15,647 homes 5.83% had...