Sql server management studio

Assignment Help Macroeconomics
Reference no: EM131271966

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: EM131271966

Questions Cloud

What was the purpose or angle of the story : What was the purpose OR angle of the story? Meaning, out of all the information available about this celebrity or personality, what did the writer chose to focus on.
Describe the fundamental challenges that organizations face : Determine the fundamental challenges that organizations face in general in regard to protecting organizational assets and information.
Impact of indias economy on the united states : Prepare a 1-2 page paper that discusses the impact of India's economy on the United States and other current world economic powers.
Find an expression for the average probability of bit error : Find an expression for the average probability of bit error as a function of K, the total number of users in the system.
Sql server management studio : 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.
Compute the maximum throughput t for a pure aloha : Compute the maximum throughput T for a pure ALOHA and a slotted ALOHA random access system, along with the load L that achieves the maximum in each case.
Case study - poseidon plc : Prepare a 2,500 word report responding to the concerns raised by the Board - The Board are particularly concerned that they are able to explain their presence as being beneficial to the local environment whilst they feel that they cannot really den..
Derive a formula for the optimal power allocation : Derive a formula for the optimal power allocation on a fading broadcast channel to maximize sum-rate.
Defining policy and its role in corporate culture : Defining policy and its role in corporate culture? Write a report on how an organization can achieve ISO 27001 certification.

Reviews

Write a Review

 

Macroeconomics Questions & Answers

  Output-consumption and investment

Assume a 2 sector economy (where the two sectors are consumption and investment) where C= $100+ 0.9 Y and I=$50

  Money against the legalization of marijuana

In the incoming election, Massachusetts voters will have the option to liberalize marijuana in their state. According to news reports, the Massachusetts alcohol industry is contributing money against the legalization of marijuana.

  Weaknesses with measurement technique

Suppose that Australia's price level is 125, the British price level is 100, and the nominal exchange rate of pounds to the dollar is £0.60 = $1. Calculate the real exchange rate of pounds to the dollar. Show all workings. Explain how the CPI is c..

  Term structure of interest rates-theories

1. What is your take-away of this part of reading; in particular, what's the building blocks of ROI? 2. What's the application of ROI in the real-world business?

  Fiscal policy in the current economic situation

Please detail the possibilities of using fiscal policy to stimulate economic activity in Denmark in a situation of economic stagnation among the most important trading partners.

  Problem regarding the ms access

You are to develop a simple database that will store notebook specification including price foreachnotebook using Microsoft Access 2003/2007/2010/2013.Followtheinstructions below.

  Suppose a town concludes that its costs on average is 3000

suppose a town concludes that its costs on average is 30.00 per household to manage the disposal of the waste generated

  Elucidate the likely effects on savings investment

Please elucidate the likely effects on Savings (Gross Private Domestic) Investment, Long Term Real Interest Rates, The Capital Stock, Natural RGDP.

  What does nyse stand for

A lot of abbreviations are used in the economics world. What does NYSE stand for?

  College education plans to start depositing money

A mechanical engineer who is anticipating paying for his daughter's college education plans to start depositing money now(year 0) and continue through year 17.

  Important part of information technology security course

Describe what social engineering is and explain its existence and prevalence. Explain why SE is an important part of an information technology security course.

  Which of output levels represents macroeconomic equilibrium

On the planet Omicron Persei 8, government spending is $1000, net taxes are $1200, and planned investment is $1400. Consumers spend according to the equation C = 100 + 0.8Yd, where Yd represents disposable income.

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