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

Cis 111 Chapter 8 Practice Lab Student Name: Graded by You will create one script file for the queries listed below and save it as eyour name-ChapsPractice.sql 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. 3 pts) Write a SELECT statement that retuns 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. (3 pts) Write a SELECT statement that returns these columns from the Products table The DateAdded colum 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. (4 pts) Write a SELECT statement that returns these colums from the Orders table A column that uses the CONVERT function to return the OrderDate column in this format: MM/DD/YYYY. In other words, use 2-digit months and days and a 4-digit year, and separate each date component with slashes. A column that uses the CONVERT function to return the OrderDate column with the date, and the hours and minutes on a 12-hour clock with an am/pm indicator. A column that uses the CONVERT function to return the OrderDate column with 2-digit hours, minutes, and seconds on a 24-hour clock. Use leading zeros for all date/time components 01s 111 Chapter 7 Practice Lab Show transcribed image text Cis 111 Chapter 8 Practice Lab Student Name: Graded by You will create one script file for the queries listed below and save it as eyour name-ChapsPractice.sql 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. 3 pts) Write a SELECT statement that retuns 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. (3 pts) Write a SELECT statement that returns these columns from the Products table The DateAdded colum 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. (4 pts) Write a SELECT statement that returns these colums from the Orders table A column that uses the CONVERT function to return the OrderDate column in this format: MM/DD/YYYY. In other words, use 2-digit months and days and a 4-digit year, and separate each date component with slashes. A column that uses the CONVERT function to return the OrderDate column with the date, and the hours and minutes on a 12-hour clock with an am/pm indicator. A column that uses the CONVERT function to return the OrderDate column with 2-digit hours, minutes, and seconds on a 24-hour clock. Use leading zeros for all date/time components
01s 111 Chapter 7 Practice Lab

Expert Answer

---

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