Question: All questions are based on the Database (eCommerce.sql) below [4 marks] Write a query to return the listing of customers who did not make purchase

All questions are based on the Database (eCommerce.sql) below [4 marks] Write a query to return the listing of customers who did not

All questions are based on the Database (eCommerce.sql) below [4 marks] Write a query to return the listing of customers who did not make purchase during the invoicing period. Sort the results by customer code. [4 marks] Write a query to list the most popular product's p_code and pdescript. Product's popularity is defined by the total quantity that have already been sold [Hint: you can use view] [4 marks] Write a PL/SQL anonymous block to list those customers' full name who has some balance. [Hint: use cursor] [3 marks] Write a PL/SQL anonymous block to calculate the subtotal of an invoice. Initialize a scalar variable to a specified invoice

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!

All questions are based on the Database (eCommerce.sql) below 1. [4 marks] Write a query to list a summary of customer balance for those customers who made purchase. More specifically, the summary...

Write a query to return the listing of customers who did not make purchase during the invoicing period. Sort the results by customer code. 2. [4 marks] Write a query to list the most popular...

The structure and contents of the Ch07_SaleCo database are shown in Figure P7.9 . Use this database to answer the following problems. 9. Write a query to count the number of invoices. 10. Write a...

11. Generate a listing of all purchases made by the customers, using the output shown in Figure P7.11 as your guide. Sort the results by customer code, invoice number, and product description. 12....

Task 1 (5 marks): Create the above tables based on the list provided above: booking, cruise, model, qualifications, roster, schedule, staff, tour, and vessel. Insert at least five records into each...

A discrete sequence {xn} can be converted into a continuous representation x(t) = ts X n= (t n ts) xn, where ts is the sampling period. (a) State two characteristic properties of Dirac's function. [2...

Hi there, i attached the screenshots of the assignment and also the two SQL files. thanks! 28% E .. T-Mobile Back 1:24 AM Assignment Details SQL Assignment Instructions: Use the SaleCo ERD listed...

Briefly describe ASCII and Unicode and draw attention to any relationship between them. [3 marks] (b) Briefly explain what a Reader is in the context of reading characters from data. [3 marks] A...

1) Write a query to return the listing of customers who did not make purchase during the invoicing period. Sort the results by customer code. 2) Write a query to list the most popular products p_code...

What is the primary difference between plasma arc welding and plasma arc cutting?

Three-year-old Will understands that his tricycle isn't alive and can't feel or move on its own. But at the beach, while watching the sun dip below the horizon, Will exclaimed, "The sun is tired....

Over / Under: Beta sold merchandise on credit with terms FOB Destination. By the end of the year, the merchandise had not been received by the customer. Beta recorded the sale and did not count the...

Below is a schedule of accounts receivable. Using the aging method, determine the ending balance in the allowance for uncollectible accounts. (how do I solve this? Pls give a step-by-step, thank...

1. How will you, as city manager, handle these requests?

1. Identify the sources for this conflict.

3. How would you address the problems that make up the situation?