Question
Write a query to return the listing of customers who did not make purchase during the invoicing period. Sort the results by customer code.
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 product's p_code and p_descript. Product's popularity is defined by the total quantity that have already been sold [Hint: you can use view] 3. [4 marks] Write a PL/SQL anonymous block to list those customers' full name who has some balance. [Hint: use cursor] 4. [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
3.38 Rating (142 Votes )
There are 3 Steps involved in it
Step: 1
Query 1 SELECT cuscode cuslname cusfname cusinitial FROM yhliw23customer WHERE c...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started