Contents of BOOKS table

$+$ Oracle SQL$*$Plus

Flo

Edt Search Options Help

ISBH

TITLE

PUBDATE

PUBID

COST

RETAIL

$1059831198$ BODYBUILD IN $10$ MINUTES A DAY

$21-$JAN$-01$

$18\mathrm{.}75$

$30\mathrm{.}95$

$0401140733$ REVENGE OF MICKEY

$14-$DEC$-01$

$14\mathrm{.}2$

$22$

$4981341710$ BUILDING A CAR WITH TOOTHPICKS $18-$MAR$-02$

$37\mathrm{.}8$

$59\mathrm{.}95$

$8843172113$ DATABASE IMPLEMENTATION

$04-$JUN$-99$

$31\mathrm{.}4$

$55\mathrm{.}95$

$3437212490$ COOKING WITH HUSHROOMS

$28-$FEB$-00$

$12\mathrm{.}5$

$19\mathrm{.}95$

$3957136468$ HOLY GRAIL OF ORACLE

$31-$DEC$-01$

$47\mathrm{.}25$

$75\mathrm{.}95$

$1915762492$ HANDCRANKED COMPUTERS

$21-$JAN$-01$

$21\mathrm{.}8$

$25$

$9959789321$ E$-$BUSINESS THE EASY WAY

$01-$MAR$-02$

$37\mathrm{.}9$

$54\mathrm{.}5$

$2491748320$ PAINLESS CHILD$-$REARING

$17-$JUL$-00$

$48$

$89\mathrm{.}95$

$0299282519$ THE WOK WAY TO COOK

$11-$SEP$-00$

$19$

$28\mathrm{.}75$

$8117949391$

BIG BEAR AND LITTLE DOVE

$08-$NOU$-01$

$5$

$5\mathrm{.}32$

$8\mathrm{.}95$

$0132149871$ HOW TO GET FASTER PIZZA

$11-$NOV$-02$

$17\mathrm{.}85$

$29\mathrm{.}95$

$9247381001$ HOW TO MANAGE THE MANAGER

$09-$ MAY$-99$

$15\mathrm{.}4$

$31\mathrm{.}95$

$01-$MAY$-01$

$21\mathrm{.}85$

$39\mathrm{.}95$

$2147428890$ SHORTEST POEMS

Based upon the contents of the BOOKS table in the accompanying figure, which of the following SQL statements will retrieve all books published by the publisher assigned Pubid $1?$

O SELECT $*$ FROM books WHERE pubid LIKE $"1"$;

$$ SELECT $*$ FROM books WHERE pubid $=1$;

$$ SELECT $*$ FROM books WHERE pubid $>1$;

$$ both a and b