A sales department director wants to identify all books in the Literature or Business category and published by Publishers 1,3 or 5. However, the result should not include any books selling for more than $35.00 

Transcribed Image Text:

S Connections ts Worksheet Query Builder select from books Query Result x ISBN SQL | All Rows Fetched: 14 in 0.005 seconds TITLE PUBID COST RETAIL DISCOUNT CATCODE (null) CATEGORY 4 18.75 30.95 (null) FITNESS 1 14.2 2 37.8 59.95 1059831198 BODYBUILD IN 10 MINUTES A DAY 21-JAN-05 20401140733 REVENGE OF MICKEY 14-DEC-05 18-MAR-06 04-JUN-03 3 31.455.95 (null) COMPUTER 28-FEB-04 4 12.5 19.95 (nul1) COOKING 31-DEC-05 3 47.25 75.95 3.8 COMPUTER 21-JAN-05 3 21.8 25 (null) COMPUTER 01-MAR-06 2 37.9 54.5 (null) COMPUTER 17-JUL-04 5 48 89.95 4.5 FAMILY LIFE 11-SEP-04 4 19 28.75 (null) COOKING 08-NOV-05 5 5.32 8.95 (null) CHILDREN 11-NOV-06 4 17.85 29.95 1.5 SELF HELP 09-MAY-03 1 15.431.95 (null) BUSINESS 22 (null) FAMILY LIFE (null) 3 CHILDREN (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) PUBDATE 3 4981341710 BUILDING A CAR WITH TOOTHPICKS 48843172113 DATABASE IMPLEMENTATION 53437212490 COOKING WITH MUSHROOMS 63957136468 HOLY GRAIL OF ORACLE 71915762492 HANDCRANKED COMPUTERS 89959789321 E-BUSINESS THE EASY WAY 92491748320 PAINLESS CHILD-REARING 10 0299282519 THE WOK WAY TO COOK 11 8117949391 BIG BEAR AND LITTLE DOVE 12 0132149871 HOW TO GET FASTER PIZZA 13 9247381001 HOW TO MANAGE THE MANAGER S Connections ts Worksheet Query Builder select from books Query Result x ISBN SQL | All Rows Fetched: 14 in 0.005 seconds TITLE PUBID COST RETAIL DISCOUNT CATCODE (null) CATEGORY 4 18.75 30.95 (null) FITNESS 1 14.2 2 37.8 59.95 1059831198 BODYBUILD IN 10 MINUTES A DAY 21-JAN-05 20401140733 REVENGE OF MICKEY 14-DEC-05 18-MAR-06 04-JUN-03 3 31.455.95 (null) COMPUTER 28-FEB-04 4 12.5 19.95 (nul1) COOKING 31-DEC-05 3 47.25 75.95 3.8 COMPUTER 21-JAN-05 3 21.8 25 (null) COMPUTER 01-MAR-06 2 37.9 54.5 (null) COMPUTER 17-JUL-04 5 48 89.95 4.5 FAMILY LIFE 11-SEP-04 4 19 28.75 (null) COOKING 08-NOV-05 5 5.32 8.95 (null) CHILDREN 11-NOV-06 4 17.85 29.95 1.5 SELF HELP 09-MAY-03 1 15.431.95 (null) BUSINESS 22 (null) FAMILY LIFE (null) 3 CHILDREN (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) PUBDATE 3 4981341710 BUILDING A CAR WITH TOOTHPICKS 48843172113 DATABASE IMPLEMENTATION 53437212490 COOKING WITH MUSHROOMS 63957136468 HOLY GRAIL OF ORACLE 71915762492 HANDCRANKED COMPUTERS 89959789321 E-BUSINESS THE EASY WAY 92491748320 PAINLESS CHILD-REARING 10 0299282519 THE WOK WAY TO COOK 11 8117949391 BIG BEAR AND LITTLE DOVE 12 0132149871 HOW TO GET FASTER PIZZA 13 9247381001 HOW TO MANAGE THE MANAGER