Skip to main content

Engineering Computer Science Oracle 12c: SQL

To write a SQL query to evaluate the average profit generated by the orders in the orders table. Required SQL query: SELECT AVG(SUM((retail-cost)*quantity)) FROM orders JOIN orderitems USING(order#) JOIN books USING(isbn) GROUP BY order#; Explanation: SELECT keyword will allow the user to retrieve the required values. AVG keyword will allow the user to calculate the average of the provided value. SUM keyword will allow the user to calculate the sum of the provided value. retail-cost, order#, and isbn are the column names. FROM keyword specifies the table name. JOIN keyword allows the programmer to join two tables and use both tables based on one common column, available in both tables. Orders, orderitems, and BOOKS are the table name. USING keyword specifies the required name of the column. GROUP BY keyword specifies the grouping of the provided column. For this query, sample tables “books” and “order “are considered in which some sample data is inserted. Based on the sample input data, the above-given query is successfully executed, and the output is given below. Sample output: AVG 10.20

To write a SQL query to evaluate the average profit generated by the orders in the orders table. Required SQL query: SELECT AVG(SUM((retail-cost)*quantity)) FROM orders JOIN orderitems USING(order#) JOIN books USING(isbn) GROUP BY order#; Explanation: SELECT keyword will allow the user to retrieve the required values. AVG keyword will allow the user to calculate the average of the provided value. SUM keyword will allow the user to calculate the sum of the provided value. retail-cost, order#, and isbn are the column names. FROM keyword specifies the table name. JOIN keyword allows the programmer to join two tables and use both tables based on one common column, available in both tables. Orders, orderitems, and BOOKS are the table name. USING keyword specifies the required name of the column. GROUP BY keyword specifies the grouping of the provided column. For this query, sample tables “books” and “order “are considered in which some sample data is inserted. Based on the sample input data, the above-given query is successfully executed, and the output is given below. Sample output: AVG 10.20

Oracle 12c: SQL

Oracle 12c: SQL

3rd Edition

ISBN: 9781305251038

Author: Joan Casteel

Publisher: Cengage Learning

See similar textbooks

Concept explainers

In a database management system, a single table is designed to obtain data of heterogeneous items. A single-table design with DynamoDB resolves the issue of raising multiple requests for the relevant data of an entity.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

Blurred answer

Chapter 11, Problem 5HOA

Chapter 11, Problem 7HOA

Students have asked these similar questions

Find the names of the pilots who are not certified to fly the aircrafts in the flight table. Sort the name by ascending order.

Chapter 11 Solutions

Oracle 12c: SQL

Ch. 11 - Prob. 1HOA Ch. 11 - Prob. 2HOA Ch. 11 - Prob. 3HOA Ch. 11 - Prob. 4HOA Ch. 11 - Prob. 5HOA Ch. 11 - Prob. 6HOA Ch. 11 - Prob. 7HOA Ch. 11 - Prob. 8HOA Ch. 11 - Prob. 9HOA Ch. 11 - Prob. 10HOA

Knowledge Booster

Background pattern image

Computer Science

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

List all information for each order item. Include an item total, which can be calculated by multiplying the Quantity and Paideach columns. Use a column alias for the calculated value to show the heading Item Total in the output.

Recommended textbooks for you

Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
CMPTR
Computer Science
ISBN:9781337681872
Author:PINARD
Publisher:Cengage

Text book image

Oracle 12c: SQL

Computer Science

ISBN:9781305251038

Author:Joan Casteel

Publisher:Cengage Learning

Text book image

Computer Science

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Course Technology Ptr

Text book image

Np Ms Office 365/Excel 2016 I Ntermed

Computer Science

ISBN:9781337508841

Author:Carey

Publisher:Cengage

Text book image

Computer Science

ISBN:9781337681872

Author:PINARD

Publisher:Cengage

SEE MORE TEXTBOOKS