Write 2 SQL
Description
Write a SELECT statement that returns these columns from the Products table (10 rows):
- The list_price column
- A column that uses the FORMAT function to return the list_price column with 1 digit to the right of the decimal point
- A column that uses the CONVERT function to return the list_price column as an integer
- A column that uses the CAST function to return the list_price column as an integer
- Write a SELECT statement that returns these columns from the Products table (10 rows):
- The date_added column
- A column that uses the CAST function to return the date_added column with its date only (year, month, and day)
- A column that uses the CAST function to return the date_added column with just the year and the month
- A column that uses the CAST function to return the date_added column with its full time only (hour, minutes, and seconds)
Slide 1 of 2
-
attachment_1attachment_1
-
attachment_2attachment_2
Explanation & Answer:
1 Project
User generated content is uploaded by users for the purposes of learning and should be used following our honor code & terms of service.
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."
