Question: Question 8 (Marks: 15) Create a PL/SQL query to display the product name, product price and delivery description. Only display the records where the difference

Question 8 (Marks: 15) Create a PL/SQL query to display the product name, product price and delivery description. Only display the records where the difference between the despatch date and delivery date is greater than three days. In your query also determine whether the product is a premium or non-premium product. *Note: All premium products have a price greater than or equal to R15 000. Sample Results PRODUCT: Plasma Stand Unit PRICE: R7 999 DESCRIPTION: Delivery contains glass items - fragile DELIVERY DAYS: 5 PRODUCT CATEGORY: Non Premium Product PRODUCT: Four Piece Wall Unit

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 General Management Questions!

Question 5 ( Marks: 1 5 ) Create a PL / SQL query to display the customer's name, employee name, donation, dispatch date and the delivery date. In your query, also display the number of days between...

Question 6 (Marks: 15) Create a PL/SQL query to display the combined customer name and the product purchased. In your query only display the products purchased with a price value over R10 000

CASE STUDY Study the following case study and answer the questions that are based thereon. COINS 4 AFRICA is a privately-owned online store producing high quality currency and commemorative coins....

please help using SQL plus or SQL Developer EMPLOYEE \ table [ [ EmplD , First _ Name,Surname,Contact _ Num,Email,Address ] , [ 1 0 1 , Cameron,Willis, 0 8 4 3 5 6 9 8 5 1 , cw@isat.co . za , 1 1...

Please try to answer all if possible :-) Practice Database - March 2021 1. Create a database in your HOME FOLDER, C-Database Systems called Practice March21.accdb a. Remember to click on the yellow...

Looking for 5.1-5.10 5. Create Queries that to do the following: (10 marki). Your queries will be marked based on whether the queries are formulated correct or not, net based on the records that are...

Eccess 1) Create a form for product table you have in your DB and Save the Form as Product Form 2) Create a form for the query No_Discount which display all the order details where there is no...

In Problem 26, explain the effect on the optimal solution of changing the daily pay for a permanent claims processor from $64 to $54. Explain the effect of changing the daily pay for a temporary...

To aid in the early detection of breast cancer women are urged to perform a self-exam monthly. Thirty-eight percent of American women perform this exam monthly. In a sample of 305 women, what is the...

1 0 ) The operating band for the overnight interest rate isA ) 5 0 basis points wideB ) defines the rate of interest the Bank of Canada charges LVTS participants with negative settlement balances at...

Divide-and-Conquer Algorithms and Recurrence Relations Theorem Practice problems 1. T(n) = T(n/2) + T(n/4) + T(n/8) + n 2. f(n) = f(n/3) + f(2n/3) + O(n)

5-19. Dont pay more than you have to; you can get our new fragrance for a price of just $50.

5-16. The board cannot act without a consensus of opinion.

5-4. What are hedging sentences and why should they be avoided unless truly necessary? [LO-3]