Consider the tapies provided below and answer the following SQL questions: Customer CustID 100 101 102 BookOrders OrderID 1001 1002 1003 1004 1005 1006 1007 Questions: a. b. c. CustName Joe Smith Andy Blake Sue Brown AccntNo. 010839 111248 061544 Title The Dark Tower Incubus Dreams Song of Susannah The Time Traveler's Wife The Dark Tower Tanequil Song of Susannah CustID Price 12.00 19.99 23.00 21.00 102 101 102 100 101 102 101 12.00 15.00 23.00 Show all customer details in Descending order of customer Name. Display a list of Book titles that cost more than $20. Only show unique titles. Display orderID and price of books 'Time' word in the title.
Consider the tapies provided below and answer the following SQL questions: Customer CustID 100 101 102 BookOrders OrderID 1001 1002 1003 1004 1005 1006 1007 Questions: a. b. c. CustName Joe Smith Andy Blake Sue Brown AccntNo. 010839 111248 061544 Title The Dark Tower Incubus Dreams Song of Susannah The Time Traveler's Wife The Dark Tower Tanequil Song of Susannah CustID Price 12.00 19.99 23.00 21.00 102 101 102 100 101 102 101 12.00 15.00 23.00 Show all customer details in Descending order of customer Name. Display a list of Book titles that cost more than $20. Only show unique titles. Display orderID and price of books 'Time' word in the title.
Chapter12: Subqueries And Merge Statements
Section: Chapter Questions
Problem 19MC
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
Knowledge Booster
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
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning