hope this is the structure your looking for.

I just need the code to use in order to solve these query searches. how to find the questions all the information should be there

In this assignment, students will use the AdventureWorks CTP3 database and practice writing CASE, SET, and DECLARE statements to build a stored procedure that can parse data quickly 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 been tasked with determining questions related to the Road-650 bicycle inventory 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 visual check of accuracy Create a Word document that includes the SQL query code used to explore the database tables and complete the following criteria. Make sure to provide a screenshot for each. The marketing department wants to know if the Road-650 bicycle as more than 10 styles currently available. Using the Product table 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 2. The marketing department has decided that it will only feature black colored Road-650 bicycles in the sales promotion. However, the 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 Building on the question three activity, the marketing department has decided that any products that currently have more than 100 unit 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 "Sales Price 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 h the corresponding region. By integrating code, the business will be able to return results quickly for users. Use the Address, StateProvince, and SalesTerritory tables and name the procedure GetRegion. TIP: Use GO. Test that your procedure works by running an EXECUTE statement ubmit 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 suc ful completion. SQLQuery1sa- DESKTOP-KOHSUSS.master (DESKTOP-KOHSUSSicride (69)-Microsoft SOL Server Management Studio File Edit View Query Project Debug Tools WindowHelp Generic Debugs master Object Explorer Editor Messages . DESKTOp-KOHSUSS (SQL Server 14.0.1000.169 . DESKTOP-KOHSUSNeide) Databases System Databases Database Snapshots AdventureWorks?016CTP3 Database Diagrams Tables Views External Resources Synonyms Programmability Query Store Service Broker Storage Security 016CTP3 a Security Server Objects H Replication PolyBase Always On High Availability Management Integration Services Catalogs SQL Server Agent (Agent XPs disabled) XEvent Profiler