The total last year sales converted in mexican pesos

Assignment Help Basic Computer Science

Reference no: EM13744992

NOTE: In answering some of the following questions you will need to use T-SQL statements learned under previous learning lessons.
Questions
1. Create a VIEW dbo.vw_Commissions to display the commissions earned last year by all sales employees. Round the result set to two decimal places and do
Unit 10 [IT234: Database Foundations]
not include any salesperson who did not earn a commission. Include the salesperson name, the commission earned, and the job title. Concatenate the salesperson first and last names.
2. Using nested queries (correlated query) to display the total Last Year Sales converted in Mexican pesos that occurred in July 1, 2005. Only nested/correlated queries will be accepted. Round the result set to two decimal places Unit10_ConvertedCommissions.sql
HINTS:
• Observe the ToCurrency column and the value corresponding to the Mexican Pesos
• Use a wildcard in the Name of the currency
• Make sure you use the correct convention for the date field
• Use the proper aggregate function
3. Display the Salesperson who earned the highest commission last year. Include the sales person name (concatenated First and Last Name), the Job Title, and the total commissions earned. Name the query Unit10_HighestCommission.sql
4. List all orders placed between August 10 and August 20 in 2005. List the order date, orders and the territory. Name the query Unit10_OrdersPalcedInAugust2005.sql

Reference no: EM13744992

Questions Cloud

Complete the external environmental scan for organization : Complete the external environmental scan for your organization. Perform an internal competitive environmental scan for your organization.

Initial cash flow and each year cash flow from the project : The machine is expected to save $35000, $45000 and $55000 in year 1,2and 3, respectively. If lion lighting has a 30% marginal tax rate, what are the initial cash flow and each year's cash flow from the project?

Analyze the significant implications of the issues : Analyze the significant implications of the issues in question for market efficiency of the healthcare system. Provide a rationale for your response.

What can today sustainable architecture learn fromvernacular : Montgomery Schuyler states "conformity to the environment is a prime virtue in domestic architecture". What can today's, sustainable architecture learn from the vernacular?

The total last year sales converted in mexican pesos : Using nested queries (correlated query) to display the total Last Year Sales converted in Mexican pesos that occurred in July 1, 2005. Only nested/correlated queries will be accepted. Round the result set to two decimal places Unit10_ConvertedCommiss..

Recognize the income tax benefit of the operating loss : Wynn Sheet Metal reported an operating loss of $160,000 for financial reporting and tax purposes in 2013. The enacted tax rate is 40%. Taxable income, tax rates, and income taxes paid in Wynn‘s first four years of operation were as follows:

Calculate the monthly mortgage payment : Calculate the monthly mortgage payment of principal and interest for the a loan with an initial balance of 150,000, an annual stated interest rate of 6%, and 30 years to maturity. Use Excel to develop this response and present your result within a..

Cash basis to the accrual basis : A company switched from the cash basis to the accrual basis for recognizing warranty expense. The unrecorded liability for warranties was $2.1 million at the beginning of the year. Its tax rate is 35%. The company booked a year-end warranty liability..

List the number (count) of unreserved room : List the guests by guest number, last name, first name and the number of times each guest has stayed in one of our hotels (include all reservations, past, current and future). Arrange the list in order from most-frequent stayer (greatest number of st..

User Account

All Pages