View the step-by-step solution to:

Question

This is the problem I am currently trying to solve. As you can see I am pulling multiple books that are all the

same with different book_num values.

Untitled-1.jpg

MindTap - Cengage Learning
IM-Ch07-Intro-SQL-Ed12
G write a query to display the auth x
Write a query to display the auth x +
X
Content
O
https://ng.cengage.com/static/nb/ui/evo/index.html?snapshotld=1565490&id=697759556&deploymentld=58359022481506391264666156&eISBN=9781337627924
Lo
. . .
X
<<
CENGAGE | MINDTAP
Write a query to display the author last na
V
Search this course
?
MAIN MENU
Coding Labs
X
My Home
Problems 7.91-7.95
E
query.sql
+
1 SELECT AU_ID, BOOK_NUM, BOOK_TITLE, BOOK_SUBJECT
Courses
Problem 91
2 FROM AUTHOR, BOOK
ORDER BY BOOK_NUM, AU_ID
A-Z
CENGAGE UNLIMITED
Browse Catalog
Write a query to display the author ID, book number, title, and subject for each book.
< / >
Sort the results by book number and then author ID (Figure P7.91). (25 rows)
Partner Offers
AU ID BOOK NUM
BOOK_TITLE
BOOK SUBJECT
Print Options
273
5235
Beginner's Guide to JAVA
Programming
383
5236
Database In the Cloud
Cloud
College Success
185
5237
Mastering the database environment
Database
603
5238
Conceptual Programming
Programming
Career Center
229
5239
1++ In Mobile Apps
Programming
460
5239
++ In Mobile Apps
Programming
Start your FREE trial of
592
5239
++ In Mobile Apps
Programming
CENGAGE UNLIMITED
218
5240
OS Programming
Programming
460
5241
JAVA First Steps
Programming
START TRIAL
559
5241
JAVA First Steps
Programming
Learn more
Figure 7.91
SQL View
+
? Help
Task
AU ID
BOOK_NUM
BOOK_TITLE
BOOK_SUBJECT
Give Feedback
Complete Problem 91 above.
185
5235
Beginner's Guide to JAVA
Programming
218
5235
Beginner's Guide to JAVA
Programming
Problem 92
229
5235
Beginner's Guide to JAVA
Programming
251
5235
Beginner's Guide to JAVA
Programming
Write a query to display the author last name, first name, book title, and replacement
cost for each book. Sort the results by book number and then author ID (Figure P7.92).
262
5235
Beginner's Guide to JAVA
Programming
(25 rows)
273
5235
Beginner's Guide to JAVA
Programming
AU_LNAME
AU_FNAME
BOOK TITLE
BOOK_COST
284
5235
Beginner's Guide to JAVA
Programming
?
383
5235
Beginner's Guide to JAVA
Programming
O
7 / 11
>

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Let our 24/7 MYSQL tutors help you get unstuck! Ask your first question.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors