Create a sql script that will produce the request

Assignment Help Database Management System

Reference no: EM132135879

SQL Assignment

In these exercises, you'll enter and run your own SELECT statements. You will use the MyGuitarShop database for these queries. If you do not already have the MyGuitarShop database, the SQL script and the instructions for creating the database are located in the Submitting Assignments module on Canvas.

Create a SQL script that will produce the requested information outlined below. After you have completed and tested the script, submit the script using the HW4 assignment link located in the Week 9 module. Include a comment at the top of the script with your name and assignment.

Also include a comment before each section of the script that identifies the exercise number. Here is an example of how the script should begin:

-- Sherry Albright (SQL Assignment)

-- Exercise 1

1. Write a SELECT statement that returns these columns from the Products table:
The ListPrice column
A column that uses the CAST function to return the ListPrice column with 1 digit to the right of the decimal point
A column that uses the CONVERT function to return the ListPrice column as an integer
A column that uses the CAST function to return the ListPrice column as an integer

2. Write a SELECT statement that returns these columns from the Products table:
The DateAdded column
A column that uses the CAST function to return the DateAdded column with its date only (year, month, and day)
A column that uses the CAST function to return the DateAdded column with its full time only (hour, minutes, seconds, and milliseconds)
A column that uses the CAST function to return the DateAdded column with just the month and day

3. Write a SELECT statement that returns these columns from the Products table:
The ListPrice column
The DiscountPercent column
A column named DiscountAmount that uses the previous two columns to calculate the discount amount and uses the ROUND function to round the result to 2 decimal places

4. Write a SELECT statement that returns these columns from the Orders table:
The OrderDate column
A column that returns the four-digit year that's stored in the OrderDate column
A column that returns only the day of the month that's stored in the OrderDate column.
A column that returns the result from adding thirty days to the OrderDate column.

Reference no: EM132135879

Questions Cloud

How strategic plan is communicated : DEVELOP AND IMPLEMENT STRATEGIC PLANS - How strategic plan is communicated effectively to team - How all required resources are organised and arranged

What is the probability that fewer : Assuming this trend continues, what is the probability that fewer than 125 bottles of beer in this particular sample are defective?

Prepare a program that asks the user to enter 10 golf scores : Design a program that asks the user to enter 10 golf scores. The scores should be stored in an Integer array.

What is the standard deviation of process distribution : A binomial process has 892 trials and a probability of success of .78 what is the standard deviation of this process distribution?

Create a sql script that will produce the request : Write a SELECT statement that returns these columns from the Products table.

Properties of the binomial distribution : Doctoral assistant ships of Ph.D students 50% have paid assistant ships. a random sample of n=200 students is chosen

What is the expected number of students : What is the expected number of students who have paid assistant ships in this sample?

Show your own very short and simple application : Show your own very short and simple application that is vulnerable to this attack. Provide another version that mitigates this issue.

What possible pairs of values a1 and a2 are returned : If transaction T2 executes with isolation level Serializable, what possible pairs of values a1 and a2 are returned by T2?

User Account

All Pages