Name

ISBN

TITLE

PUBDATE PUBID COST

RETAIL CATEGORY

Structure of the BOOKS table

$*$ Oracle SQL$*$Plus

Edit

Search Options Help

File

Name

PUBID NAME

CONTACT PHONE

Structure of the PUBLISHER table

Nu$11?$

Type

NOT NULL VARCHAR$2(10)$

VARCHAR$2(30)$

DATE

NUMBER $(2)$

NUMBER $(5,2)$

NUMBER$(5,2)$

VARCHAR$2(12)$

Null?

NOT HULL

Type

NUMBER $(2)$

VARCHAR$2(23)$

VARCHAR$2(15)$

VARCHAR$2(12)$

Which of the following SQL statements will display the publisher name, book title, and retail price of all books that cost more than $$35\mathrm{.}95?$

O SELECT name, title, retail

FROM books, publisher

WHERE cost $>35\mathrm{.}95$;

$$ SELECT name, title, retail

FROM books NATURAL JOIN publisher

WHERE cost$35\mathrm{.}95$

$$ SELECT p$.$name, b$.$title, b$.$retail

FROM books b NATURAL JOIN publisher p

WHERE b$.$cost $>35\mathrm{.}95$;

$$ none of the above