MYSQL

• • rma.csv
  • customers.csv
  • orders.csv

2. Import the data from each file into tables.
   1. Use the QuantigrationRMA database, the three tables you created, and the three CSV files preloaded into Codio.
   2. Use the import utility of your database program to load the data from each file into the table of the same name. You will perform this step three times, once for each table.
3. Write basic queries against imported tables to organize and analyze targeted data. For each query, include a screenshot of the query and its output. You should also include a brief, 1- to 3-sentence description of the output.
   1. Write an SQL query that returns the count of orders for customers located only in the city of Framingham, Massachusetts.
      1. This query will use a table join between the customers and orders tables. The query will also use a where clause.
      2. How many records were returned?
   2. Write an SQL query to select all of the customers located in the state of Massachusetts.
      1. Use a WHERE clause to limit the number of records in the customers table to only those who are located in Massachusetts.
      2. Record an answer to the following question: How many records were returned?

Reason RMAID OrderID Status Step RMA varchar(25) int int varchar(50) varchar(15) Then, the line goes to the Orders table, which has the following information: Orders int OrderID CustomerID SKU Description int varchar(20) varchar(50) Finally, the line coming out of the Orders table goes to the Customers table, which has the following information: CustomerID FirstName LastName Street City State ZipCode Telephone Customers int varchar(25) varchar(25) varchar(50) varchar(50) varchar(25) int varchar(15)