Sql statement FIND the book code and book title for each book whose price is greater than the book price of every book that has the type MYS?

Answer 1

SELECT a.BOOK_CODE, a.TITLE

FROM BOOK a, BOOK b

WHERE a.PRICE > b.PRICE AND b.TYPE = 'MYS'

Answer 2

SELECT book_code, book_title
FROM books
WHERE price > (SELECT MAX(price) FROM books WHERE type = 'MYS');