Contents of the BOOKS table

$*$ Oracle SQL$-$Plus

Search

$0\mathrm{.}4$ pts

$22$

$25$

ISBN

TITLE

PUBDATE

PUBID

COST

RETAIL

$1059831198$ BODYBUILD

NUTES A DAY

$21-$JAN$-01$

$18\mathrm{.}75$

$30\mathrm{.}95$

$0401140733$ REVENGE OF MICKEY

$14-$DEC$-01$

$14\mathrm{.}2$

$4981341710$ BUILDING

CAR WITH TOOTHPICKS $18-$MAR$-02$

$37\mathrm{.}8$

$59\mathrm{.}95$

$8843172113$

DATABASE

IMPLEMENTATION

$04-$JUN$-99$

$31\mathrm{.}4$

$55\mathrm{.}95$

$3431244$S CUUKING WITN MUSHKUUMS

$28-$FEB$-00$

$19\mathrm{.}95$

$136468$ HOLY GRAIL OF ORACLE

$47\mathrm{.}25$

$2492$ HANDCRANKED COMPUTERS

$21-$JAN$-01$

$21\mathrm{.}8$

E$-$BUSINESS

THE EASY WAY

$01-$MAR$-02$

$54\mathrm{.}5$

$8320$ PAINLESS CHILD$-$REARING

THE WOK WAY TO COOK

$11-$SEP$-00$

BIG BEAR AND LITTLE DOVE

$08-$NOU$-01$

$5\mathrm{.}32$

$0132149871$ HOW TO GET FASTER PIZZA

$9247381001$

HOW TO MANAGE THE MANAGER

$09-$MAY$-99$

$15\mathrm{.}4$

SHORTEST POEMS

$01-$MAY$-01$

$21\mathrm{.}85$

Based on the contents of the BOOKS table, which of the following SQL statements will return the total profit generated by books in the COOKING category?

$$ SELECT TOTAL$($retail$-$cost$)$ FROM books

WHERE category $=$ 'COOKING;

O SELECT TOTAL$($retail$-$cost$)$ FROM books

GROUP BY category;

O SELECT SUM$($retail$-$cost$)$ FROM books

WHERE category $=$ 'COOKING;

$$ SELECT SUM$($retail$-$cost$)$ FROM books

GROUP BY category $=$ 'COOKING;