Skip to main content

Engineering Computer Science ORACLE 12C: SQL

Program plan: The main purpose of the query is to display the titles of the books and the profit earned for each book provided, that book is paid for in order number 1002. Required query: select title, concat('$', round( (retail-cost)*quantity, 2)) as profit from books b join orderitems oi on b.isbn = oi.isbn where order# = 1002 and paidEach = 'yes'; Explanation: SELECT keyword will allow the user to retrieve the required values. title, retail, and cost are the names of the columns. as keyword is used to give an alias to the column name concat function concatenates the given strings. round function keeps the specified number of decimal places. FROM keyword specifies the table name. books and orderitems are the default table names. where keyword is used to specify condition(s). and keyword is used to combine two or more conditions. For this query, two tables named “books” and “orderitems” are considered and some sample data is inserted. Based on the sample data, the above-given query is successfully executed, and the output is given below. Sample Output: TITLE PROFIT adventures of tom sawyer $44

Program plan: The main purpose of the query is to display the titles of the books and the profit earned for each book provided, that book is paid for in order number 1002. Required query: select title, concat('$', round( (retail-cost)*quantity, 2)) as profit from books b join orderitems oi on b.isbn = oi.isbn where order# = 1002 and paidEach = 'yes'; Explanation: SELECT keyword will allow the user to retrieve the required values. title, retail, and cost are the names of the columns. as keyword is used to give an alias to the column name concat function concatenates the given strings. round function keeps the specified number of decimal places. FROM keyword specifies the table name. books and orderitems are the default table names. where keyword is used to specify condition(s). and keyword is used to combine two or more conditions. For this query, two tables named “books” and “orderitems” are considered and some sample data is inserted. Based on the sample data, the above-given query is successfully executed, and the output is given below. Sample Output: TITLE PROFIT adventures of tom sawyer $44

ORACLE 12C: SQL

ORACLE 12C: SQL

17th Edition

ISBN: 9781305449947

Author: CASTEEL

Publisher: CENGAGE L

See similar textbooks

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

Blurred answer

Chapter 10, Problem 2HOA

Chapter 10, Problem 4HOA

Students have asked these similar questions

4. |z + 5 - 5i| = 7

14. dz, C: |z❘ C: |z❘ = 0.6 ze² - 2iz H

14. dz, C: |z❘ C: |z❘ = 0.6 ze² - 2iz H

Chapter 10 Solutions

ORACLE 12C: SQL

Ch. 10 - Prob. 1RQ Ch. 10 - Prob. 1HOA Ch. 10 - Create a list of all customer numbers along with...Ch. 10 - Prob. 3HOA Ch. 10 - Prob. 4HOA Ch. 10 - Prob. 5HOA Ch. 10 - Prob. 6HOA Ch. 10 - Prob. 7HOA Ch. 10 - Prob. 8HOA Ch. 10 - Prob. 9HOA

Ch. 10 - Produce a list of each customer number and the...

Knowledge Booster

Background pattern image

Similar questions

SEE MORE QUESTIONS

Recommended textbooks for you

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
CMPTR
Computer Science
ISBN:9781337681872
Author:PINARD
Publisher:Cengage
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage

Text book image

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

Computer Science

ISBN:9780357392676

Author:FREUND, Steven

Publisher:CENGAGE L

Text book image

Oracle 12c: SQL

Computer Science

ISBN:9781305251038

Author:Joan Casteel

Publisher:Cengage Learning

Text book image

Np Ms Office 365/Excel 2016 I Ntermed

Computer Science

ISBN:9781337508841

Author:Carey

Publisher:Cengage

Text book image

Programming with Microsoft Visual Basic 2017

Computer Science

ISBN:9781337102124

Author:Diane Zak

Publisher:Cengage Learning

Text book image

Computer Science

ISBN:9781337681872

Author:PINARD

Publisher:Cengage

Text book image

Programming Logic & Design Comprehensive

Computer Science

ISBN:9781337669405

Author:FARRELL

Publisher:Cengage

SEE MORE TEXTBOOKS