Question: PRINT 'CIS2275, Lab Week 6, Question 6 [3pts possible]: The Examples database will be used for this problem Calculate the percent of total sales of

PRINT 'CIS2275, Lab Week 6, Question 6 [3pts possible]: The Examples database will be used for this problem Calculate the percent of total sales of each sales reps in 2016. The calculation will show the percentage of each reps total sales compared to the overall total sales for all years.For example, if the overall sales for all years was 10,000 and rep''s total sales for 2016 was 1000, the percentage would be 10% Insert dollar sign and apply rounding. Use Subquery and JOIN. There will be 4 valid records Rep ID Reps last name Reps total Sales Reps percentage ---------------------------------------------------------------------------------------------- 1 Thomas $499,168.73 5.60% 2 Martinez $887,695.75 9.97% 4 Winters $72,443.37 0.81% 5 Kramer $45,182.44 0.50%

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 Mathematics Questions!

In 2024, the Westgate Construction Company entered into a contract to construct a road for Santa Clara County for $10,000,000. The road was completed in 2026. Information related to the contract is...

NEED LAB WEEK 6 ANSWER AND WEEK 5 ANSWER THEY GO TOGETHER. LAB 5 IS BELOW LAB WEEK 6 CIS355A Week 6 LabDatabase Processing OBJECTIVES Add database operations to the Week 5 Stock program. PROBLEM:...

7:09 PM Wed Oct 4 88% File Details 2023FS-COMP_SCI-201L-009L O Switch To Light Mode Lab Week 6 Reading and Writing Files Skills Required . Read and write Files Work with arrays and vectors, Create...

in C++ Lab Week 6 Reading and Writing Files Skills Required Read and write Files Work with arrays and vectors, Create Functions, Include Headers and other files, Loops (while, for), Conditional (if,...

The code must be ONLY in C-language. Need the code in an hour. This won't take too long.Thanks! 11.5 Lab Week 6: Drawing a half arrow This program outputs a downwards facing arrow composed of a...

HERe is the code for CMS.java. when i run this code using the main program from class that's in the package, it won't delete cms resources. it adds the resources with addresource() method. want you...

Logistics Submit required materials by midnight of Wednesday on Gradescope. There are no late days or extensions for the lab assignments. Important Notice: We will run your programs on bertum...

Project Scope Statement Project Name Project Number Prioritization Project Manager Owner(s) Statement of Work Project Description and Project Product This section is typically a detailed...

I would like assist for my assessment. The subject is Subsidiary Accounts and Ledgers and Foundation Skills. T-1.8.1 Details of Assessment Term and Year 1, 2017 Time allowed Week 2-7 Assessment No 1...

Java How to Program, Early Objects ISBN-13: 9780133813432 Project Name: C2800_Proj1_RaceGame Source File Name: (Submit zip of these) RaceGame.java (contains main) RaceCar.java RaceGame is a text...

Assessment 1 - Context This assessment requires that you play the role of the project manager of a team assigned to develop a new product. You will be preparing for 2 separate meetings with the...

Answer Problem 9.61 for the epoxidation of trans-4-octene. CH3CH2CH2CH=CHCH2CH2CH3 CH3CH2CH2CH-CHCH2CH2CH3 RCO3H 4-Octene 4,5-tane

On 1 January 2019, Farmer Bhd. enters a lease contract with ABC Sdn Bhd, for the rental of 3 printers, a cutting system, and a copy machine for 2 years. The machines will be returned to ABC Sdn Bhd...

What does research show about entrepreneurs who fail in their first venture? Multiple Choice Question They are more likely to create better business plans later. They waited too long to begin their...

Oust the Turtle Company has the following balances on December 31, 2020: Cash on hand 4,500.00 Cash in bank A 33,000.00 Cash in bank X 50,000.00 Cash in bank C 822,999.72 Cash on hand includes $ 3....