A sales department director wants to identify all books in the Literature or Business category and published
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
Related Book For
Posted Date:
Students also viewed these databases questions
-
5. Predict the results of these studies on learning: A. The effect of taking a practice test after learning versus not taking a practice test on the grade a student receives on the real exam taken...
-
Although regional trade agreements exist around the world, we still don't have a solid answer to the question of whether they're moving the world closer to free trade on a global scale. O True O...
-
During an afternoon at work, you receive various requests for data stored in the database. As you fulfill each request, you decide to document the SQL statements you used to find the data to assist...
-
Why is using APA Style important for effective scholarly writing?
-
Suppose that a liquid carries a drug into a 100-cc organ at a rate of 5 cc s and leaves the organ at the same rate. Suppose that the concentration of the drug entering is 0.06 g cc. If initially...
-
Khalid Inc. has the following selected financial data: There were no preferred dividends in arrears. (a) Calculate the following ratios for 2017: (1) Rate of return on common shareholders' equity,...
-
The chapter says that a measurement system can affect society in several ways. As an example, consider the use of GMAT scores in the United States. A. Do they shape how people think about the ability...
-
Prepare the necessary adjusting entries at December 31, 2011, for the Microchip Company for each of the following situations. Assume that no financial statements were prepared during the year and no...
-
E7-4 (Static) Identifying Relevant Costs and Calculating Differential Costs [LO 7-2] Maria Turner just graduated from college with a degree in accounting. She planned to enroll immediately in the...
-
The Chartered Financial Analyst (CFA) designation is the de facto professional certification for the financial industry. Employers encourage their prospective employees to complete the CFA exam....
-
Carla Vista Company earns 7% on an investment that will return $469,000 8 years from now. Click here to view the factor table. What is the amount Carla Vista should invest now to earn this rate of...
-
Problem 6 (10%: Consider portfolio manager with a $20,500,000 equity portfolio under management. The manager wishes to hedge against a decline in share values using stock index futures. Currently a...
-
You are a full-time student at PSU working part-time at the Best Buy Store located at Cascade Station. The manager of your store wants you to identify potential customers on campus and sell Dell...
-
Can someone help me those 2 questions using C++ only 1. generate a histogram of 20,000 randomly generated integer numbers according to a normal distribution with a user-specified mean and standard...
-
In 2000 only 17% of the assets invested in hedge funds came via funds of funds, by 2007 this proportion had grown to over 40%, however by 2016 the proportion had again reduced significantly to 20%....
-
3 Question 40 (2.5 points) Listen Exactly 35 years from today, Indira wants to have $1,000,000 in her retirement account. If Indira's retirement account pays interest of 13.6% per year, but with...
-
Activity 6.12: Document for Analysis - Improving Wordy Request(LOs 1-5) Directions : The following wordy, inefficient, and disorganized message invites department managers to three interviewing...
-
Make an argument that Williams had a right to delay the closing until after August 1.
-
Which of the following defines a relationship in which each occurrence of data in one entity is represented by only one occurrence of data in the other entity? a. One-to-one b. One-to-many c....
-
Which operator can you use to find any books with a retail price of at least $24.00?
-
Which of the following can contain repeating groups? a. Unnormalized data b. 1NF c. 2NF d. 3NF
-
Use this website to review the outline of the Bank of Japans objectives. Summarize the mission of the Bank of Japan. How does this mission relate to intervening in the foreign exchange market?
-
As MADD executive director Chuck Hurley describes it, Before the 1980s, drunk driving was how people got home. It was normal behavior. In May of that year, Candy Lightner's 13-year-old daughter was...
-
In the early 1990s, most programs that were working to alleviate homelessness in American cities followed a similar model. Homeless men and women could visit shelters, but could not obtain permanent...
Study smarter with the SolutionInn App