Question: 2 . From the Sales.SalesPerson table write a query in SQL to calculate by dividing the total year - to - date sales ( SalesYTD

2. From the Sales.SalesPerson table write a query in SQL to calculate by dividing the total year-to-date sales (SalesYTD) by the commission percentage (CommissionPCT). Return SalesYTD, CommissionPCT, and the value rounded to the nearest whole number. (AW-81)

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

Q:

Prepare and execute each of the queries listed using the "Adventureworks2012" database in SQL Server. When all of your queries are complete, cut and paste the SQL Syntax into a word document to be...

Q:

You will need to install SQL Server Express along with database services (there is one file that will install both), if you have not done so already, and you will need to attach the...

Q:

Using the database(SQL), write the queries for all the following questions. More information is provided at the end. From the Emp table, write a query to find those employees whose commission is more...

Q:

Database subject Solve this pleasy by using Orcal SQL This is the emp table: DROP TABLE EMP; DROP TABLE DEPT; DROP TABLE SALGRADE; create table dept( deptno number(2,0), dname varchar2(14), loc...

Q:

Database subject Solve this pleasy by using Orcal SQL This is the emp table: DROP TABLE EMP; DROP TABLE DEPT; DROP TABLE SALGRADE; create table dept( deptno number(2,0), dname varchar2(14), loc...

Q:

Can you help me out with questions 10-14 and problem 16. I attached two images because the scenario is on another page . Include InvoiceID, InvoiceDat X d. Calculate total sales for each inventory...

Q:

Can you help me out with questions 10-14 and problem 16. I attached two images because the scenario is on another page . Include InvoiceID, InvoiceDat X d. Calculate total sales for each inventory...

Q:

BIZ3189 Management Information Systems Take-home Exam 1 The tasks in this exam aim at developing a basic level of understanding on Excel and how you can use it to develop Decision Support Systems....

Q:

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

Q:

SQL Query Design Module Preview This guide contains a preview of the materials for all module courses in this series: Using a Relational Database Management System Single Table Query Commands...

Q:

The MUNSON Company is structured with Jane Wagner as the owner and general manager. She currently has a span of management of ten people; (six sales representatives, one bookkeeper/office manager,...

Q:

On January 1, 2016, Iowa Company purchased a delivery truck for $32,000. The van was estimated to have a 5-year useful life or 100,000 miles. Salvage value was estimated at $2,000. The van was driven...

Q:

lot - for - Profits, Bankruptcies and Estates Help Sore 8 Ealt Subenit A gift to a not - for - profit school that is not restricted by the donor is recorded with a credit to Multiple Choice 3 4 8 Non...

Q:

Given the following functions, find and simplify (f-g)(8.5). f(z) = 2+1 g(x)=-8x-4 Provide your answer below: (f-g)(8.5)=