Question: Need a commandAccording to the retail in the books table, we can infer which gift should be given in promotion Promotion Table GIFT MINRETAIL MAXRETAIL

Need a commandAccording to the retail in the books table, we can infer which gift should be given in promotion

Promotion Table

GIFT MINRETAIL MAXRETAIL
BOOKMARKER 0 12
BOOK LABELS 12.01 15
BOOK COVER 35.01 56
FREE SHIPPING 56.01 999.99

Books Table

ISBN TITLE PUBDATE PUBID COST RETAIL DISCOUNT CATEGORY QOH
1059831198 BODYBUILD IN 10 MINUTES A DAY 21-Jan-2014 4 18.75 30.95 - FITNESS 5
0401140733 REVENGE OF MICKEY 14-Dec-2014 1 14.2 22 - FAMILY LIFE 50
4981341710 BUILDING A CAR WITH TOOTHPICKS 18-Mar-2015 2 37.8 59.95 3 CHILDREN 30
8843172113 DATABASE IMPLEMENTATION 04-Jun-2012 3 31.4 55.95 - COMPUTER 2
8843172115 DATABASE IMPLEMENTATION 04-Jun-2012 3 31.4 55.95 - COMPUTER 1
3437212490 COOKING WITH MUSHROOMS 28-Feb-2013 4 12.5 19.95 - COOKING 100
3957136468 HOLY GRAIL OF ORACLE 31-Dec-2014 3 47.25 75.95 3.8 COMPUTER 0
1915762492 HANDCRANKED COMPUTERS 21-Jan-2014 3 21.8 25 - COMPUTER 26
9959789321 E-BUSINESS THE EASY WAY 01-Mar-2015 2 37.9 54.5 - COMPUTER 60
2491748320 PAINLESS CHILD-REARING 17-Jul-2013 5 48 89.95 4.5 FAMILY LIFE 3

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Q1 List all order numbers and their ship dates for orders shipped after March 15, 2018. Q2 List all customers that live in Massachusetts or California. Show first and last name as well as city and...

Q:

SQL Questions 1 through 4 - Unit 2 Lab Activity - Need help on these SQL statements, please note that I am using the cloud database version of apex.oracle. Lab Activity Complete the following SQL...

Q:

Unit 6 Lab - SQL statements - Need help on these CIS 338: SQL/Oracle Learning Unit 6: Lab Activity Lab Activity Complete the following SQL exercises using the JustLee Books database. Launch Oracle...

Q:

Here is the script given: Looking for the answer to the Advanced Challenge Quetion. CREATE TABLE warehouses (wh_id NUMBER(2), location VARCHAR(12) ); INSERT INTO warehouses VALUES (10, 'Boston');...

Q:

Unit 6 Lab - SQL statements - Need help on these CIS 338: SQL/Oracle Learning Unit 6: Lab Activity Lab Activity Complete the following SQL exercises using the JustLee Books database. Launch Oracle...

Q:

IN SQL -To perform this activity, refer to the tables in the JustLee Books database. The Marketing Department of JustLee Books is preparing for its annual sales promotion. Each customer who places an...

Q:

Read the instructions To perform these assignments, refer to the tables shared in p: Drive. tables to share.txt that is shared in the drive P:\viji\week 9\tables to share.txt. Generate and test two...

Q:

Unit 3 Assignment - SQL statements - Please be aware that I am using APEX.ORACLE.com and the SQL command statement must run successfully without errors. 1. Which orders shipped after April 1, 2009?...

Q:

To perform this activity, refer to the tables in the JustLee Books database. The Mareting Department of JustLee Books is preparing for its annual sales promotion. Each customer who places an order...

Q:

DROP TABLE CUSTOMERS CASCADE CONSTRAINTS; DROP TABLE ORDERS CASCADE CONSTRAINTS; DROP TABLE PUBLISHER CASCADE CONSTRAINTS; DROP TABLE AUTHOR CASCADE CONSTRAINTS; DROP TABLE BOOKS CASCADE CONSTRAINTS;...

Q:

In a mixture of the two gases, the partial pressures of CH 4 (g) and O 2 (g) are 0.175 atm and 0.250 atm, respectively. a. What is the mole fraction of each gas in the mixture? b. If the mixture...

Q:

On January 1, 2020, Miya Co. issued a 5% redeemable preference share with aggregate parvalue of P3,000,000 for P2,800,000. Transaction cost incurred amounted to P212,173.65. The shareholders can...

Q:

If you have saved up $ \ $ 6 8 0 , 0 0 0 $ to retire and you put your money into a saving account with a 3 . 6 \ % APR, how long can you survive off of this money if you spend $ \ $ 6 , 0 0 0 $ every...

Q:

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Q:

2. Develop a program for effectively managing diversity.

Q:

7. What is coaching? Is there only one type of coaching? Explain.

Q:

8. Discuss reasons why many managers are reluctant to coach their employees.