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)
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."
Complete the 
Complete the order payment after filling in the order form. We’ll receive your order and assign it to a writer.
The assigned writer will complete your paper and forward it to our Editing Team for review and approval.
Once approved by the editor, the completed paper will be uploaded to your account for you to download, review and approve.