Sql server management studio to create the queries

Assignment Help Business Management
Reference no: EM131267291

Use SQL Server Management Studio to create the queries.

1. For all products with a quantity on hand of 100 or more, list their product number, description, and quantity on hand. List the products in alphabetical order by description. Use the default column headings.

2. An increase of 10% in the salary of employees with the job title of Clerk is being considered. For all clerks, list the employee last name, current salary, and projected new raised salary. Order the list by salary, from the highest salary to the lowest salary. Use a secondary sort order of employee last name. For column headings, use: Name, Salary, and Raised Salary.

3. For each employee hired on or after January 1, 2012, list the employee's first name, last name, hire date, and phone number (which is the phone number of the department in which the employee works). Order the list primarily by last name and secondarily by first name. Use the default column headings.

4. For each customer that is located in either Florida or Georgia and that has a credit limit of $10,000 or more, list the company name, state, credit limit, and account representative last name (the last name of the employee that serves as the customer's account representative). Order the list alphabetically by company name. For column headings, use: Customer, State, Credit Limit, and Account Rep.

5. List the product description, customer company name, and order date for each time that a Junior product was ordered by a customer in 2012. (Assume that the descriptions of all such products begin with the word Junior.) Order the list by product description. Use the default column headings.

6. For all customers, list the company name and the total number of orders placed by the customer. Include all customers, even those who have never placed an order. Order the customers in the list by the number of orders placed, from most to fewest. For any customers with the same number of orders, arrange them within the list alphabetically by company name. Use Customer Name and Order Count as the column headings.

7. For all departments, list the department number, department name, and average salary of the employees in that department. Do not include the salaries of employees who are clerks in the average salary calculation. Only include a department in the list if it has an average salary (of non-clerk employees) greater than $5,000. List the departments by average salary, from highest to lowest. For column headings use: Dept. No., Department Name, and Average Salary.

8. For the customer who placed the first order with Acme, as well as the customer who placed the most recent order with Acme, list the company name, phone number, last name of sales representative, and order date. The customer placing the most recent order should be listed first. For column headings use: Company Name, Telephone, Salesperson, and Date.

Reference no: EM131267291

Questions Cloud

Minimise third party interference and enhance privacy : How can one incorporate a password on a program code to minimise third party interference and enhance privacy?
What does ron popeil bring to personal selling : What does Ron Popeil bring to personal selling that makes him so effective?- Explain how Popeil's selling tactics allow him to achieve the desired objectives of sales promotions.
Erp system support all levels of management : How is the role of ERP system different from traditional TPS, MIS, DSS, and others? Can an ERP system support all levels of management?
Describe a cultural diversity policy for the firm : Describe a cultural diversity policy for the firm expanding overseas operations. Highlight any differences that might arise in some Middle Eastern countries where a distribution center is currently being built
Sql server management studio to create the queries : For all products with a quantity on hand of 100 or more, list their product number, description, and quantity on hand. List the products in alphabetical order by description. Use the default column headings.
How each can affect the success of leader in driving change : Culture and gender have proven to be variables largely affecting the success of change implementation. For this discussion, state and defend your position regarding culture and gender and how each can affect the success of a leader in driving chan..
Client program for rock paper scissors game : Create a server and client program for Rock Paper Scissors game in java. The Server waits for the two clients connected to Server then start a game. Then It prints the result how wins by player1 and player2.
Analyze the relationship between organizational theory : Write a 525-word paper that analyzes the differences between two technological management theories applied to one organizational design. Analyze the relationship between organizational theory and organizational structure and design. Determine the va..
How would you evaluate the company''s leadership methods : For this discussion, conduct some independent research and locate an article that addresses a current company's leadership style and dysfunction. How would you evaluate the company's leadership methods differently - now - based on what you have le..

Reviews

Write a Review

 

Business Management Questions & Answers

  What are the three basic functions of a firm

What are the three basic functions of a firm?- Identify the 10 strategic operations management decisions.- Name four areas that are significant to improving labor productivity?

  Types of international organization focus

What are the three types of international organization focus and how would you describe each?

  Calculating the expected profit

Do 100 simulations on a worksheet and determine the probability Hatch is successful with each of these choices and determine the best of these three by calculating the expected profit.

  Explanation of initiatives to facilitate changewhat are

explanation of initiatives to facilitate changewhat are three initiatives that can be used to facilitate change amongst

  Explain what strategies should the argentina division employ

Explain what strategies should the Argentina division employ to capture market share and What strategies would a division of your camera company employ to meet the goals established by your corporation.

  Strategic landscape for organization

Analyze the strategic landscape for your own organization or one with which you are familiar. What are the critical changes that it will face in the near future?

  Unemployment and inflation

Imagine that you have a fixed 30-year interest rate for your mortgage, and the economy has experienced unanticipated inflation. Examine who the winner and loser would be. Is it the borrower or the lender in the given scenario? Provide support for ..

  Describe theory of motivation

Show the list at least one reason why you think workers may be more motivated by job security rather than benefits and salary in difficult economic times.

  What kinds of preventions could be taking place

What kinds of preventions could be taking place that perhaps aren't?

  Personal communication methods

What personal communication methods would you use to deal with aggressive patients in a medical office? "communication with aggressive patients"?

  Percent of american adults sleep

Americans are increasingly skimping on their sleep (National Geographic News, February 24, 2005). A health expert believes that American adults sleep on average of 6.2 hours on weekdays with a standard deviation of 1.2 hours. To answer the followi..

  Write an informal business proposal memo

Write an informal business proposal memo. Your company is interested in venturing into the world of social media as part of a growth strategy.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd