The rest of the queries involve IN, ANY, ALL, HAVING and/or subqueries 9. Give t

Question

The rest of the queries involve IN, ANY, ALL, HAVING and/or subqueries 9. Give the title and price of every book whose price is larger than the average price of all books. author AuthorNum DECIMAL (2,0) AuthorLast AR(12) Authorfirst OAR(10) book ? BookCode AR(4) Title CHAR(40) PubCode CHAR(3) TYPE CHAR(3) DcB DATE Price DECIMAL (4,2) PAPERBACK CHAR(1) publisher PubCode CHAR(3) Publame CHAR(25) ODcD DATE Oty AR(20) wrote BookCode CHAR(4) AuthorNum DECIMAL (20) SEQUENCE DECIMAL (1,0) branch Branch Num DECIMAL (2,0) ? BockCode0AR(4) Branch Num DECIMAL (2,0) OnHand DECIMAL (2,0) BranchName CHAR(50) Location CHAR(50) StaffSize DECIMAL (2,0)

Explanation / Answer

SELECT Title, Price FROM book b
(SELECT avg(sal) avg_price FROM book b1)
WHERE b.Price > b1.avg_price

**Comment for any further queries. Upvote if the answer is satisfactory.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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