Really having a hard time on this assignment.

Details: This assignment serves to benchmark competencies 1.5: Apply knowledge of database architecture and design to meet organizational needs and In this assignment, students will use the AdventureWorks CTP3 database and practice writing CASE, SET, and DECLARE statements to build a stored The marketing department wants to promote sales of the Road-650 bicycle. It has developed a request list related to the promotion, and you have Please note that when SQL queries are run, results are generated in the form of data. This data should be exported and saved to an Excel file for a Create a Word document that includes the SQL query code used to explore the database tables and complete the following criteria. Make sure to 1. The marketing department wants to know if the Road-650 bicycle has more than 10 styles currently available. Using the Product table 2. The marketing department has decided that it will only feature black colored Road-650 bicycles in the sales promotion. However, the 3.1: Utilize technology for data collection, storage, analysis, and reporting of information. procedure that can parse data quickly been tasked with determining questions related to the Road-650 bicycle inventory. visual check of accuracy provide a screenshot for each. create a statement using IF THEN logic to trigger on whether there are more or less than 10 of Road-650 bicycle units available. Submit the statement and the result of the query marketing department may want to modify the sale at a later date. Use a DECLARE and SET statement to pre-set a variable color to "Black." Using the variable, run a query to show all the type of bicycles including all fields 3. Building on the question two activity, add the "Quantity" and "ListPrice. Filter the results to only items in Finished Goods Storage 4. Building on the question three activity, the marketing department has decided that any products that currently have more than 100 units in stock will be discounted by 10%. All other products will have a 5% discount as part of the promotion. Create a CASE statement that modifies the "ListPrice" into a new field called "SalesPrice 5. Your manager has asked you to create a stored procedure for an application the business is developing. For the application, management has requested that when a "City" is selected, it returns with the corresponding region. By integrating code, the business will be able to return results quickly for users. Use the Address, StateProvince, and Sales Territory tables and name the procedure "GetRegion." TIP: Use GO. Test that your procedure works by running an EXECUTE statement. Submit the Word document (with screenshots). APA style is not required, but solid academic writing is expected This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion. You are not required to submit this assignment to LopesWrite Please Note: Assignment will not be submitted to the facuity member until the "Submit" button under Final Submission" is clicked. Details: This assignment serves to benchmark competencies 1.5: Apply knowledge of database architecture and design to meet organizational needs and In this assignment, students will use the AdventureWorks CTP3 database and practice writing CASE, SET, and DECLARE statements to build a stored The marketing department wants to promote sales of the Road-650 bicycle. It has developed a request list related to the promotion, and you have Please note that when SQL queries are run, results are generated in the form of data. This data should be exported and saved to an Excel file for a Create a Word document that includes the SQL query code used to explore the database tables and complete the following criteria. Make sure to 1. The marketing department wants to know if the Road-650 bicycle has more than 10 styles currently available. Using the Product table 2. The marketing department has decided that it will only feature black colored Road-650 bicycles in the sales promotion. However, the 3.1: Utilize technology for data collection, storage, analysis, and reporting of information. procedure that can parse data quickly been tasked with determining questions related to the Road-650 bicycle inventory. visual check of accuracy provide a screenshot for each. create a statement using IF THEN logic to trigger on whether there are more or less than 10 of Road-650 bicycle units available. Submit the statement and the result of the query marketing department may want to modify the sale at a later date. Use a DECLARE and SET statement to pre-set a variable color to "Black." Using the variable, run a query to show all the type of bicycles including all fields 3. Building on the question two activity, add the "Quantity" and "ListPrice. Filter the results to only items in Finished Goods Storage 4. Building on the question three activity, the marketing department has decided that any products that currently have more than 100 units in stock will be discounted by 10%. All other products will have a 5% discount as part of the promotion. Create a CASE statement that modifies the "ListPrice" into a new field called "SalesPrice 5. Your manager has asked you to create a stored procedure for an application the business is developing. For the application, management has requested that when a "City" is selected, it returns with the corresponding region. By integrating code, the business will be able to return results quickly for users. Use the Address, StateProvince, and Sales Territory tables and name the procedure "GetRegion." TIP: Use GO. Test that your procedure works by running an EXECUTE statement. Submit the Word document (with screenshots). APA style is not required, but solid academic writing is expected This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion. You are not required to submit this assignment to LopesWrite Please Note: Assignment will not be submitted to the facuity member until the "Submit" button under Final Submission" is clicked