Contents of BOOKS table

$+$ Oracle SQL$*$Plus

Fle Edt Search Options

Help

ISBN

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 MUSHROOMS

$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\mathrm{.}32$

$8\mathrm{.}95$

$0132149871$ HOW TO CET 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$

$2147428890$ SHORTEST POEMS

$01-$MAY$-01$

$21\mathrm{.}85$

$39\mathrm{.}95$

Based upon the contents of the BOOKS table in the accompanying figure, which of the following queries will list all books stored in the BOOKS table with a retail price of more than $$38$ sorted by retail price?

$$ SELECT $*$ FROM books WHERE retail $>38$ SORT BY retail;

$$ SELECT $*$ FROM books WHERE retail $>38$ SORTED BY retail;

$$ SELECT $*$ FROM books WHERE retail $>38$ ORDERED BY retail;

$$ SELECT $*$ FROM books WHERE retail $>38$ ORDER BY retail;