Question: I am pulling up my tables and still do not see what I need. See Picture of my Codio. Review the scenario for this activity

I am pulling up my tables and still do not see what I need. See Picture of my Codio.
Review the scenario for this activity in the guidelines and rubric. Then complete the steps below as you work through the directions for this activity. Replace the bracketed text with your screenshots and responses to the prompts. Size each screenshot and its explanation to fit approximately one-quarter of the page with the description written below the screenshot. Review the Template Screenshot Example linked in the guidelines and rubric for this assignment to see an example of how screenshots for your assignment should look.
RMA Report
Write a report to respond to the managers requests. In the report, you should complete the following actions:
Summarize the data youve been working with.
Identify key information that will help the company streamline operations.
Your report should explain your findings in a way nontechnical stakeholders can understand and use.
Use the steps below to capture the required data and produce the analysis report.
Begin by writing SQL commands to capture specific usable data for your analysis. You already preloaded the data you need into Codio.
Specifically, the product manager wants you to complete the following analysis:
A. Analyze the number of returns by state and describe findings to include in your report.
[Insert screenshot and brief explanation here.]
B. Analyze the percentage of returns by product type and describe findings to include in your report.
[Insert screenshot and brief explanation here.]
Write a report to clearly summarize your RMA data analysis for stakeholders. When you summarize the results, consider the following questions:
A. How does the data provide the product manager with usable information?
B. What are the potential flaws in the data that has been presented?
C. Are there any limitations on your conclusions or any other ways of looking at your findings that you havent considered? Clearly communicate your findings to stakeholders.
[Write your report here.]```
mysql> USE QuantigrationUpdates;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> SHOW QuantigrationUpdates;
ERROR 1064(42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Qua
ntigrationUpdates' at line 1
mysql> SELECT state, COUNT(*) AS return_count
-> FROM rma_data
-> GROUP BY state
-> ORDER BY return_count DESC;
ERROR 1146(42S02): Table 'QuantigrationUpdates.rma_data' doesn't exist
mysql> SELECT state, COUNT(*) AS number_of_returns
-> FROM returns
-> GROUP BY state
-> ORDER BY number_of_returns DESC;
ERROR 1146(42S02): Table 'QuantigrationUpdates.returns' doesn't exist
mysql> SHOW Tables;
|+-----------------------------------+
4 rows in set (0.00 sec)
mysql> USE QuantigrationRMA;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> sHOW Tables;
+---------------------------+
+-------------------------------+
| Collaborator |
| Customers
| Orders
RMA
4 rows in set (0.00 sec)
```
I am pulling up my tables and still do not see

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!