Contents of BOOKS table

$*$ Oracle SQL$*$Plus

Fle

Edit

Search

Options

Help

ISBN

TITLE

PUBDATE

$185983119880$DYBUILD IN $10$ MINUTES A DAY

$21-$JAN$-01$

$6401140733$ REVENGE OF MICKEY

$14-$DEC$-01$

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

$8843172113$ DATABASE IMPLEMENTATION

$04-$ JUN$-99$

$3437212498$ COOKING WITH MUSHROOMS

$28-$FEB$-00$

$3957136468$ HOLY GRAIL OF ORACLE

$1915762492$ HANDCRANKED

COMPUTERS

$31-$DEC$-01$

$21-$JAN$-01$

$9959789321$ E$-$BUSINESS THE EASY WAY

$01-$MAR$-82$

$2491748320$ PAINLESS CHILD$-$REARING

$17-$JUL$-00$

$0299282519$ THE WOK WAY TO COOK

$11-$SEP$-00$

$8117949391$ BIG BEAR AND LITTLE DOVE

$08-$NOU$-01$

$0132149871$ HOW TO GET FASTER PIZZA

$11-$NOV$-02$

$9247381001$ HOW TO MANAGE THE MANAGER

$09-$MAY$-99$

$2147428890$ SHORTEST POENS

$01-$MAY$-01$

PUBID

$4$

$2$

$3$

$3325$

COST

$18\mathrm{.}75$

$14\mathrm{.}2$

$37\mathrm{.}8$

$31\mathrm{.}4$

$12\mathrm{.}5$

$47\mathrm{.}25$

$21\mathrm{.}8$

$37\mathrm{.}9$

$48$

$19$

$5\mathrm{.}32$

$17\mathrm{.}85$

$154$

$21\mathrm{.}85$

RETAIL

$30\mathrm{.}95$

$22$

$59\mathrm{.}95$

$55\mathrm{.}95$

$19\mathrm{.}95$

$75\mathrm{.}95$

$25$

$54\mathrm{.}5$

$89\mathrm{.}95$

$28\mathrm{.}75$

$8\mathrm{.}95$

$29\mathrm{.}95$

$31\mathrm{.}95$

$39\mathrm{.}95$

Based upon the contents of the BOOKS table in the accompanying figure, which of the following queries will retrieve all book titles that are in the Business or Computer category and have a retail price of more than $$35\mathrm{.}00?$

$$ SELECT title FROM books

WHERE category $=$ 'BUSINESS' OR 'COMPUTER' AND retail $>35$;

$$ SELECT title FROM books

A WHERE category $=$ 'BUSINESS' OR category $=$ COMPUTER' AND retail $>35$;

$$ SELECT title FROM books

WHERE $($category $=$ 'BUSINESS' OR category $=$ COMPUTER'$)$ AND retail $>35$;

$$ SELECT title FROM books

WHERE category $=$ 'BUSINESS' OR category $=$ COMPUTER' AND $($retail $>35)$;