DAD 220 7-1 Project Two: Analyzing Databases

1. Begin by writing SQL commands to capture usable data (which you have preloaded into Codio) for your analysis. Specifically, the product manager wants you to investigate and analyze the following: o Analyze the frequency of returns by state and describe your findings in your report. I ran a query to find the frequency of returns per state and found that Massachusetts has the highest number of returns with 988 returns. With this information I can report return data and potentially discuss options to reduce or find similarities in returns within the company. o Analyze the percentage of returns by product type and describe your findings in your report I ran a query to determine the percentage of returns by product. The results are the product with the highest rate of return is BAS-48-1 C at 22.1%. Showing the products that are returned at the highest percentage allows us me to report this information so we can research these products more to see if there is a commonality with why these products are returned ..............................................,,,,,,,,,,,,,,,,,,,,.CONTINUED