Step Two: Directions

Load and Query the Data

In Step One, you set up a customer RMA database using SQL to create tables and placed your work in the Project One Template. In this step, continue to place your work in the Project One Template as you follow the directions below.

The three data files you will use for this project are preloaded into Codio:

RMA.csv

Customers.csv

Orders.csv

Specifically, you must address the following rubric criteria:

Import the data from each file into tables.

Use the QuantigrationUpdates database, the three tables you created, and the three CSV files preloaded into Codio.

Use the import utility of your database program to load the data from each file into the table of the same name. You$$ll perform this step three times, once for each table.

Provide the SQL commands you ran against MySQL to complete this step.

Write basic queries against the imported tables to organize and analyze the targeted data. For each query, include a screenshot of the query and its output. Also, include a one$-$ to three$-$sentence description of the output.

Write a SQL query that returns the count of orders for customers located only in Framingham, Massachusetts.

This query will use a table join between the Customers and Orders tables. The query will also use a WHERE clause.

Record an answer to the following question: How many records were returned?