Question: Using Procedures, create a procedure for the following items. 1.Report the account representative for each customer. 2.Report total payments for Atelier graphique. 3.Report the total

Using Procedures, create a procedure for the following items. 1.Report the account representative for each customer. 2.Report total payments for Atelier graphique. 3.Report the total payments by date. 4.Report the products that have not been sold. 5.List the amount paid by each customer. 6.How many orders have been placed by Herkku Gifts? 7.Report the payments of a specific customer input. 8.Report those payments greater than $100,000. Sort the report so the customer who made the highest payment appears first. 9.List the value of 'On Hold' orders. 10.Report the number of orders 'On Hold' for each customer. 11. Report the top 3 most ordered products. 12. Label the customers according to their credit limit. Black -> Premium -> Gold -> Silver (Ikaw buot sa values) 13. Report the total revenue according to the customer's country.

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!

1.As used in PSA 560, the term "subsequent events" refers to a.Events occurring the date of the financial statement. b.Events occurring after the date of the auditor's report c.Events occurring...

Assessment Investigate and discuss the importance of review and evaluation of financial performance planning monitoring. Assessment description This assessment requires candidates to answer the...

You are about to issue the auditors report for Ayewaso Company Ltd, a listed client. Half way through the year the company suffered a major computer systems failure which destroyed the accounting...

ASSESSMENT TASKS - ASSIGNMENT 1 Page 2 ASSIGNMENT 1 Task Using the information contained in the Scenario below, please complete the following 6 tasks. You must complete each task for your submission...

TANGLEWOOD CASEBOOK for use with STAFFING ORGANIZATIONS 5th Ed. Kammeyer-Mueller 1 TANGLEWOOD CASEBOOK To accompany Staffing Organizations, fifth edition, 2006. Prepared by John Kammeyer-Mueller...

I have attached both the chapters from which you will be answering the following question. Ch 8 (p 387 of text or p 35 of the pdf) ?Exercise D. Prepare the bank reconciliation and any required...

Fact Find Initial Interview: Time Date Location Referred by: A. Personal Details Applicant 1 Applicant 2 Full Name of Applicant Full Name of Applicant Mr Mrs Miss OMS Dr Mr Mrs Miss OMs Dr Full Name...

QUESTION: WRITE EXECUTIVE SUMMARY FOR CUCINA LTD PROJECT 300 WORDS MSC Applied Research Project Cucina Ltd. Competitive advantage through data integrity Company History Cucina Ltd. is an Irish...

1. Enis falsely accuses Monalisa of stealing from Island Tours, Inc., their employer. Enis's statement is defamatory only if a. a third party hears it. b. Monalisa has not been caught. c. the...

How do you create a new table in SQL? What is the purpose of the INSERT statement in 1, 2, SQL? 3, How do you update data in a table in SQL? 4, How do you retrieve data from multiple tables in SQL?...

Word Problem 1 3 - 1 8 ( Algo ) [ LU 1 3 - 3 ( 1 ) ] Bankrate.com reported on a shocking statistic: only \ ( 5 5 \ % \ ) of workers participate in their company's retirement plan. This means that \ (...

A manufacturer has beginning and ending finished goods inventory of $500,000 and $400,000 respectively. Also, the cost of goods manufactured id $120,000. what is the cost of giods sold?

3. What do you do to stimulate and support the creativity in others?

2. What are your challenges in the creative process?

___ 28. I am most fulfilled in my work when I feel that I have complete financial and employment security.