Writing Queries with Built-In Functions

Part 1 Using the AdventureWorks database and the Production schema write a query that will create the following result from the table Product: NAME will start selling on SELLSTARTDATE. NAME and SELLSTARTDATE are columns in the table. SELLSTARTDATE must be in the format mm/dd/yyyy. Take a screen shot of the SQL windows and results and paste it here.

Part 2 Using the AdventureWorks database and the Production schema write a query that will create the following result from the table Product: NAME with a color of COLOR will start selling in the month of SELLSTARTDATE. NAME, COLOR and SELLSTARTDATE are columns in the table. SELLSTARTDATE must be the month name, e.g, 01 would be January. Eliminate any rows that have a NULL value in COLOR. Take a screen shot of the SQL windows and results and paste it here.

Part 3 Using the AdventureWorks database and the Person schema, select from the table Address AddressLine1, the first three characters of AddressLine1, a column that replaces all zeroes in AddressLine1 with a dash, and the AddressLine1 in reverse order. Use appropriate aliases for each column. Take a screen shot of the SQL windows and results and paste it here.

For such or any other type of programming homework, simply consider our assignment help service.

Do My paper price
Pages (550 words)
Approximate price: -