Skip to main content

Engineering Computer Science Oracle 12c: SQL

To write a SQL query to evaluate the author that wrote the books that are most frequently purchased by the customers of JustLee Books. Required SQL query: SELECT lname, fname FROM bookauthor JOIN author USING(authorid) WHERE isbn IN (SELECT isbn FROM orderitems GROUP BY isbn HAVING SUM(quantity) = (SELECT MAX(COUNT(*)) FROM orderitems GROUP BY isbn)); Explanation: SELECT keyword will allow the user to retrieve the required values. lname, fname, isbn, and authored are the column names. FROM keyword specifies the table name. Orderitems is the table names. WHERE keyword specifies the condition criteria. IN keyword allow the user to search data within the provided range or set of values. GROUP BY keyword specifies the column names grouped together to produce the required result. HAVING clause specifies the condition for columns written inside the group by clause. For this query, sample tables “books” ,”orderitems”,”bookauthor” and “author “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: lname Fname NELSON BECCA

To write a SQL query to evaluate the author that wrote the books that are most frequently purchased by the customers of JustLee Books. Required SQL query: SELECT lname, fname FROM bookauthor JOIN author USING(authorid) WHERE isbn IN (SELECT isbn FROM orderitems GROUP BY isbn HAVING SUM(quantity) = (SELECT MAX(COUNT(*)) FROM orderitems GROUP BY isbn)); Explanation: SELECT keyword will allow the user to retrieve the required values. lname, fname, isbn, and authored are the column names. FROM keyword specifies the table name. Orderitems is the table names. WHERE keyword specifies the condition criteria. IN keyword allow the user to search data within the provided range or set of values. GROUP BY keyword specifies the column names grouped together to produce the required result. HAVING clause specifies the condition for columns written inside the group by clause. For this query, sample tables “books” ,”orderitems”,”bookauthor” and “author “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: lname Fname NELSON BECCA

Oracle 12c: SQL

Oracle 12c: SQL

3rd Edition

ISBN: 9781305251038

Author: Joan Casteel

Publisher: Cengage Learning

See similar textbooks

Concept explainers

Basic SQL Queries

Structured Query Language is the full form of SQL. It is a high-level language used to communicate with a relational database. It is used for creating, storing and accessing contents of a relational database. SQL is used to write the queries which are ex…

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

Blurred answer

Chapter 12, Problem 4HOA

Chapter 12, Problem 6HOA

Students have asked these similar questions

Show the customer ID and name for all the customers who have ordered both products with IDs 3 and 4 on the same order.

7. List all customers who were referred to the bookstore by another customer. List eachcustomer’s last name and the number of the customer who made the referral.

Chapter 12 Solutions

Oracle 12c: SQL

Ch. 12 - Prob. 2MC Ch. 12 - Prob. 10MC Ch. 12 - Prob. 1HOA Ch. 12 - Prob. 2HOA Ch. 12 - Prob. 3HOA Ch. 12 - Prob. 4HOA Ch. 12 - Prob. 5HOA Ch. 12 - Prob. 6HOA Ch. 12 - Prob. 7HOA Ch. 12 - Prob. 8HOA

Ch. 12 - Prob. 9HOA Ch. 12 - 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.

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

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

SEE MORE TEXTBOOKS