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.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.Order the results on MyTempTable by SalesOrderID.Add a timestamp field called "DateRan" and update it to the current date.Explain how to drop the table and start over.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.

Assignment 08 K01 Windows Operating Systems Directions:Be sure to make an electronic copy of your answer before submitting it to Ashworth College for grading. Unless otherwise stated, answer in complete sentences, and be sure to use correct English spelling and grammar. Sources must be cited in APA format. Refer to the "Assignment Format" page for specific format requirements. Using Task Manager and Tracking System Performance: Open PowerPoint, select a Blank Presentation, and change the layout to Blank. Save your presentation to the location where you save your files in a new folder named Chapter 5 with the name Lastname_Firstname_05_Task_Performance Note: After each use of PowerPoint, you will save and minimize its window.Copy the data folder gowin10_1e_pe_c_05_data to your Documents folder. If necessary, set the View to Details.Navigate to This PC › Documents gowin10_1e_pe_p_05_data › Kansas City › Accounting.Using File Explorer, open KC_AC_Loan Presentation, KC_AC_All_Rooms_Analysis, and KC_AC_Report_Shareholders. If necessary, maximize each application window as you open it.Open Task Manager and, if necessary, click Fewer details. Capture an image of the screen. Display the PowerPoint Lastname_Firstname_05_Task_Performance window and paste the contents of the Clipboard on the slide.In the Task Manager window, click More details, click the Performance tab and, if necessary, click Disk 0 (C:).Capture an image of the Task Manager window. Display the PowerPoint Lastname_Firstname_ 05_Task_Performance window, add a new Blank slide, and paste the contents of the Clipboard on the slide.In the Task Manager window, click the App History tab, if necessary, scroll down, right-click Maps, and click Switch to.If necessary, resize and reposition the Maps window so that a portion of the Task Manager is visible and capture an image of the screen.Display the PowerPoint Lastname_Firstname_05_Task_Performance window, add a new Blank slide, and paste the contents of the Clipboard on the slide. Close all windows except PowerPoint.Open Task Manager and, if necessary, click More details. Click the Performance tab and click Open Resource Monitor. Click the Overview tab and maximize the window. As necessary, expand the Disk section and collapse the CPU, Network, and Memory sections. Capture the screen, display the PowerPoint window, add a new Blank slide, and paste the contents of the Clipboard on the slide. Close all open windows except PowerPoint.In the taskbar search box, type performance monitor and then select and maximize Performance Monitor Desktop app. If necessary, expand Monitoring Tools and click Performance Monitor.Open Word and Excel, click Performance Monitor on the taskbar, and click Freeze Display. On the menu bar, click Action, and click Properties. In the Performance Monitor Properties dialog box, click the Graph tab. On the Graph tab, click in the Title box, and type CPU Usage showing the opening of Word and Excel In the Vertical axis box, type Percent Used Click OK and close the dialog box.Capture the screen, display the PowerPoint window, add a new Blank slide, and paste the contents of the Clipboard on the slide. Unfreeze the Display.Save the presentation, close all open windows, and submit the PowerPoint file as directed by your instructor. For this part of the exam, you must have an administrator account on the computer that you are using. Grading Rubric Please refer to the rubric on the next page for the grading criteria for this assignment.

The purpose of this assignment is to examine similarities and differences in characteristics of effectiveness for several familiar leadership roles. In a three- to four-page paper (excluding the title and reference pages) Identify the characteristics by which the effectiveness of the following leaders might be evaluated: an assistant coach, a teacher, and a minister. Prioritize and explain the rationale for these characteristics. Discuss the ethical issues or challenges associated with prioritization. Compare and contrast the extent to which there are unique or similar characteristics across the different roles, and the extent to which the criteria are measurable. For example, some of the characteristics you might identify for the role of assistant coach might include the leadership behind a team’s win-loss record, player perceptions, team morale, etc.