WHY DO I get this error:SELECT TOP(3) p.name FROM publisher p ERROR at line 5: ORA-00923: FROM keyword not found where expected for the follow query: Select p.name FROM publisher p JOIN Editor e1 on works_for = publisher WHERE p.city = 'OKC' AND p.name IN ( SELECT TOP(3) p.name FROM publisher p JOIN Book b ON p.name = b.published_by JOIN Edit ed ON w.bISBN = b.ISBN JOIN Editor e ON e.SSN = ed.eSSN ORDER BY e.salary DESC );
oracle sql
Publisher (name, phone, city), PK: name.
Book (ISBN, title, year, published_by, previous_edition, price), PK: ISBN, FK: published_by refs Publisher, previous_edition refs Book.
Author (SSN, first_name, last_name, address, income), PK: SSN.
Write (aSSN, bISBN), PK: (aSSN, bISBN), FK: aSSN refs Author, bISBN refs Book.
Editor (SSN, first_name, last_name, address, salary, works_for, book_count), PK: SSN, FK: works_for refs Publisher.
Edit (eSSN, bISBN), PK: (eSSN, bISBN), FK: eSSN refs Editor, bISBN refs Book.
Author_Editor (aeSSN, hours), PK: aeSSN, FK: aeSSN refs Author, aeSSN refs Editor.
WHY DO I get this error:SELECT TOP(3) p.name FROM publisher p ERROR at line 5: ORA-00923: FROM keyword not found where expected
for the follow query:
Select p.name
FROM publisher p
JOIN Editor e1 on works_for = publisher
WHERE p.city = 'OKC' AND p.name IN (
SELECT TOP(3) p.name FROM publisher p
JOIN Book b ON p.name = b.published_by
JOIN Edit ed ON w.bISBN = b.ISBN
JOIN Editor e ON e.SSN = ed.eSSN
ORDER BY e.salary DESC
);
Provide the name of each publisher that is located in ‘OKC’ and is one of the top three publishers in terms of the total amount of salary it pays its editors
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
