Question: Prompt Your team has been given various date sets in order to analyze information and summarize the findings. These are in the form of simple


Prompt Your team has been given various date sets in order to analyze information and summarize the findings. These are in the form of simple return merchandise authorizations, or RMAs. Your task is to write brief summaries that capture the results of the analysis to present to the product manager, who may or may not have a technical background. This is why you should write the summaries for an audience of nontechnical stakeholders. Write a detailed summary of your analysis of the bulleted items below. Prepare your summary for nontechnical stakeholders. Use the list below to guide the structure and organization of your report. Write SQL commands that capture specific, usable data that can be used in your analysis. Analyze the results of queries to identify specific information that can be presented in your summary. 1. Sales by region: A. Analyze sales by state to determine where the company has the largest customer base. ysql> Select Customers. state As State, Count () As Product_Sales_Number From Customers Inner Join Orders On Customers. CustomerID = Orders. Cust omer ID Group By State Order By Product_Sales_Number Desc Limit 10; State | Product_Sales_Number Massachusetts 982 Arkansas 854 West Virginia 843 Oregon 842 Alabama 838 Idaho 838
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
