How do I list List the ISBN, title, author last name(s), retail price, and the promotional gift for all books in SQL?

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

How do I list List the ISBN, title, author last name(s), retail price, and the promotional gift for all books in SQL?

CUSTOMERS
Customer#
Lastname
Firstname
Email
Address
City
State
Zip
Referred
Region
ORDERS
Order#
Customer#
Orderdate
Shipdate
Shipstreet
Shipcity
Shipstate
Shipzip
Shipcost
ORDERITEMS
Order#
Item#
ISBN
Quantity
Paideach
BOOKS
ISBN
Title
Pubdate
PublD
Cost
Retail
Discount
Category
PROMOTION
Gift
Minretail
Maxretail
BOOKAUTHOR
ISBN
AuthorID
PUBLISHER
PublD
Name
Contact
Phone
AUTHOR
AuthorlD
Lname
Fname
Transcribed Image Text:CUSTOMERS Customer# Lastname Firstname Email Address City State Zip Referred Region ORDERS Order# Customer# Orderdate Shipdate Shipstreet Shipcity Shipstate Shipzip Shipcost ORDERITEMS Order# Item# ISBN Quantity Paideach BOOKS ISBN Title Pubdate PublD Cost Retail Discount Category PROMOTION Gift Minretail Maxretail BOOKAUTHOR ISBN AuthorID PUBLISHER PublD Name Contact Phone AUTHOR AuthorlD Lname Fname
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

This is incorrect. Can you provide the correct solution?

Solution
Bartleby Expert
SEE SOLUTION
Knowledge Booster
Multiple table
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
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education