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

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

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadline.


Click Here to Make an Order Click Here to Hire a Writer