Working with JOINS “Using the ssh, Oracle database 11g” 1. List books written by

Question

Working with JOINS “Using the ssh, Oracle database 11g”

1. List books written by author’s last name. Complete using both the where clause and the From clause. tables needed include books, bookauthor, and author

2. Narrow the same query down to books written by an author with the last name Adams. Perform the search using the author name. Complete using both the where clause and the From clause.

3. Non-equality Join: What gift will a customer who orders the book Shortest Poems receive? Use the actual book retail value to determine the gift.

4. Create an alphabetical list of all criminals, including criminal ID, name, violent offender status, parole status, and any know aliases.

---------------

** this is the table we work on it

select table_name

from user_tables;

** In fact, this is all the information of tables that I have.

TABLE NAME ACCT BONUS ACCTMANAGER ALIASES APPEALS AUTHOR B00KAUTHOR CATEGORY CRIMES CRIME CHARGES CRIME CODES CRIME OFFICERS TABLE NAME CRIMINALS GROCERY OFFICERS PROB CONTACT PROB OFFICERS PRODUCTS PROMOTION PUBLISHER SENTENCES TESTING WOW 22 rows selected.

Explanation / Answer

1) select b.book_name, a.last_name from books b join bookauthor ba on (b.book_id = ba.book_id) join author a on (a.auth_id = ba.auth_id) order by a.last_name;

2) select b.book_name, a.last_name from books b join bookauthor ba on (b.book_id = ba.book_id) join author a on (a.auth_id = ba.auth_id) where a.last_name = 'Adams' order by a.last_name;

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.