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 ListPrice column

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

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

d) A column that uses the CAST function to return the ListPrice 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 DateAdded column

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

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

d) A column that uses the CAST function to return the DateAdded 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 OrderDate column

b) 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.

c) 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.

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

Query goes here

Screen Shot goes here

Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.