[Solved]Cis 111 Chapter 9 Practice Lab Student Name Graded Create One Script File Queries Listed S Q37277545

Cis 111 Chapter 9 Practice Lab Student Name Graded by You will create one script file for the queries listed below and save it as cyour name ChapSPractice.sq Put a comment above each query indicating the problem number such as .-Query #1. You will review your answers with me or another student during a class session. You will need to use the GuitarShop database. 1. (2 pts) 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 2. (2 pts) Write a SELECT statement that retums 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 3. (3 pts) Write a SELECT statement that returns these columns from the Orders table The CardNumber column The length of the CardNumber column The last four digits of the CardNumber column When you get that working right, add the column that follows to the result set. This is more difficult because the column requires the use of functions within functions A column that displays the last four digits of the CardNumber column in this format xxxx-xxxx-xxxX-1234. In other words, use Xs for the first 12 digits of the card number and actual numbers for the last four digits of the number 4. (3 pts) Write a SELECT statement that returns these columns from the Orders table: The OrderlD column The OrderDate column A column named ApproxShipDate that’s calculated by adding 2 days to the OrderDate column The ShipDate column A column named DaysToShip that shows the number of days between the order date and the ship date When you have this working add a WHERE clause that retrieves just the orders for March 2016 01s 111 Chapter 7 Practice Lab Show transcribed image text Cis 111 Chapter 9 Practice Lab Student Name Graded by You will create one script file for the queries listed below and save it as cyour name ChapSPractice.sq Put a comment above each query indicating the problem number such as .-Query #1. You will review your answers with me or another student during a class session. You will need to use the GuitarShop database. 1. (2 pts) 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 2. (2 pts) Write a SELECT statement that retums 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 3. (3 pts) Write a SELECT statement that returns these columns from the Orders table The CardNumber column The length of the CardNumber column The last four digits of the CardNumber column When you get that working right, add the column that follows to the result set. This is more difficult because the column requires the use of functions within functions A column that displays the last four digits of the CardNumber column in this format xxxx-xxxx-xxxX-1234. In other words, use Xs for the first 12 digits of the card number and actual numbers for the last four digits of the number 4. (3 pts) Write a SELECT statement that returns these columns from the Orders table: The OrderlD column The OrderDate column A column named ApproxShipDate that’s calculated by adding 2 days to the OrderDate column The ShipDate column A column named DaysToShip that shows the number of days between the order date and the ship date When you have this working add a WHERE clause that retrieves just the orders for March 2016
01s 111 Chapter 7 Practice Lab

Expert Answer

---

Answer to Cis 111 Chapter 9 Practice Lab Student Name Graded by You will create one script file for the queries listed below and s… . . .