Sql-data management studio | Computer Science homework help

Using SQL Data Management Studio Only please perform the instructions  below showing screenshots of the each step. Using the Template Provided and with the Database provided.

Using the Northwind database, write a SQL SELECT statement that will retrieve the data for the following questions:

Don't use plagiarized sources. Get Your Custom Essay on
Sql-data management studio | Computer Science homework help
From as low as $8/Page
Order Essay
  1. Display the character constant ‘Greeting’ with a column heading of ‘Hello.’
    1. 1 row returned.
  2. Display all data from the categories tables without specifying the names of the table columns. Order the results by CategoryName.
    1. 8 rows returned.
  3. Display all employees’ names, last name first, and then first name, hire date and home phone number. Order the results by employee name, last name first, and then first name.
    1. 9 rows returned.
  4. Modify query 3 so that the column headings are as follows: ‘Last Name,’ ‘First Name,’ ‘Date of Hire,’ and ‘Home Phone Number.’
    1. 9 rows returned.
  5. Display the product name and quantity per unit, units in stock, and unit price for all products that have a unit price greater than $50. Order the results by unit price in descending order.
    1. 7 rows returned
  6. Display the Name of all U.S.-based suppliers. Order the results by Name in ascending order.
    1. 4 rows returned.
  7. Display the Order Id, ShipName, Order Date, and Freight of all orders that have a freight >/= 50 and </= 100; a ship country of Austria, Brazil, or France; and a Ship City that starts with an ‘S.’ Use, BETWEEN, IN, and LIKE for the WHERE clause conditions. Order the results by ShipName in ascending order.
    1. 13 rows returned.
  8. Rewrite query 7 to remove the use of BETWEEN and IN, and replace with the equivalent use of =, <, >, </=, >/= and AND and OR expressions.
    1. 13 rows returned.
  9. Select the Employee’s First Name, concatenated to the Last name, separated by a space. Call the column ‘Employee Name,’ the length of this employee name Length, the location of the first ‘a’ in the name ‘A Location,’ and the 5–9 characters from the name ‘Substring.’ Order the results by the Employee Name using the alias.
    1. 9 rows returned.
  10. For each customer, show the number of orders placed, and the largest, smallest and total freight ordered. Only show those customers who have placed more than 15 orders.
    1. 9 rows returned.

Please submit your assignment.

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more
Confirm Eligibility