Name

ISBN

TITLE

PUBDATE PUBID COST

RETAIL CATEGORY

Structure of the BOOKS table

$*$ Oracle SQL$*$Plus

File

Edit Search Options Help

Nane

PUBID NAME

CONTACT PHONE

Type

NOT HULL VARCHAR$2(10)$

VARCHAR$2(30)$

DATE

NUMBER$(2)$

NUMBER $(5,2)$

NUMBER $(5,2)$

VARCHAR$2(12)$

Null?

Type

NOT NULL NUMBER$(2)$

VARCHAR$2(23)$

VARCHAR$2(15)$

VARCHAR$2(12)$

Structure of the PUBLISHER table

Which of the following SQL statements will display the title of each book in the BOOKS table and the name of its publisher?

O SELECT title, name

FROM publisher, books;

$$ SELECT title, name

FROM publisher NATURAL JOIN books;

$$ SELECT title, name

FROM publisher, books

WHERE p$.$pubid $=$ b$.$pubid;

$$ both b and c