Need help with the sql server database (how to work with data types)

Watch the videos on SQL Training online. SQL Trim, Rtrim, Ltrim, SQL Substring, SQL Like Filter, SQL Convert Function, Cast Function, How to filter Datetime in SQL Server

NOTE: ONLY RETURN THE TOP 10 ROWS!

1. Write a SELECT statement that returns these columns from the db1.MyGuitarShop.Products table:

a) The List Price column

b) A column that uses the CAST function to return the List Price column with 1 digit to the right of the decimal point

c) A column that uses the CONVERT function to return the List Price column as an integer

d) A column that uses the CAST function to return the List Price column as an integer

Query goes here

Screen Shot goes here

2. Write a SELECT statement that returns these columns from the db1.MyGuitarShop.Products table:

a) The Date Added column

b) A column that uses the CAST function to return the Date Added column with its date only (year, month, and day)

c) A column that uses the CAST function to return the Date Added column with its full time only (hour, minutes, seconds, and milliseconds)

d) A column that uses the CAST function to return the Date Added column with just the month and day

Query goes here

Screen Shot goes here

3. Write a SELECT statement that returns these columns from the db1.MyGuitarShop.Products table:

a) The Order Date column

b) A column that uses the CONVERT function to return the Order Date 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.

c) A column that uses the CONVERT function to return the Order Date column with the date, and the hours and minutes on a 12-hour clock with an am/pm indicator.

d) A column that uses the CONVERT function to return the Order Date column with just the time in a 24-hour format, including the milliseconds.