Advanced Queries

The purpose of this assignment is to conduct advanced queries for the creation of separate reports.

For this assignment, continue to play the role of the data analyst for Adventure Works Cycling Company. Your manager has asked you to localize query results into a temporary table to avoid running the same queries repeatedly and to better track the data. This will also free up network resources for the company. Saving queries is of the utmost importance since temporary tables are lost when you disconnect from the server. Failing to save a query will result in the need to rebuild the code for the temporary table.

Using the queries completed in the Topic 4 assignment, complete the steps below and address the questions.

Please note that when SQL queries are run, results are generated in the form of data. This data should be exported and saved to Excel for a visual check of accuracy.

Create a Microsoft Word document that includes the SQL query code used to explore the database tables and answer the following questions.

1. Create a basic temporary table from work done in Topic 4, question 5 and call it “MyTempTable.” Write a SELECT statement to query the new data.
2. Order the results on MyTempTable by SalesOrderID.
3. Add a timestamp field called “DateRan” and update it to the current date.
4. Explain how to drop the table and start over.
5. Explain how the table can be re-added?

Compile the Excel data file and Word document containing the SQL queries and answers to the questions into a .zip file and submit to your instructor.

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.