Joins “Using the ssh, Oracle database 11g” * for the table: select table_name fr
ID: 3779993 • Letter: J
Question
Joins “Using the ssh, Oracle database 11g”
* for the table:
select table_name
from User_tables;
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.
Outer Join Question
4. Create an alphabetical list of all criminals, including criminal ID, name, violent offender status, parole status, and any know aliases.
---------------------------------------------------------------------------------------------------
** Please I would have all the solution has a a letter like this ex from other question: cls, cc or a ,b ... etc
SELECT cls.criminal_id, cls.first, cls.last, cc.crime_code, cc.fine_amount
FROM criminals cls JOIN crimes cr
ON cr.criminal_id = cls.criminal_id
JOIN crime_charges cc
ON cc.crime_id = cr.crime_id
ORDER BY criminal_id, first, last, crime_code, fine_amount;
Explanation / Answer
Consider there are three tables as books , authors, users.
1. select books.book_name, authors.last_name
from books
inner join authors
ON books.author_id=authors.author_id;
2. select books.book_name, authors.last_name
from books
inner join authors
ON books.author_id=authors.author_id
where books.author_name like '%Adams%'
3.select books.book_name, users.user_name
from books
inner join user
ON books.book_id=users.book_id
where books.book_price < 500
4. we can add a condition as "order by asc" to the criminal name table. It will sort all the names in asscending oder from a ->z.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.