EssayproSolutions

(Solved) : Mysql Rmacsv Customerscsv Orderscsv Import Data File Tables Use Quantigrationrma Database Q44014010 . . .

MYSQL

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

2. Import the data from each file into tables.
   1. Use the QuantigrationRMA database, the three tablesyou created, and the three CSV files preloaded into Codio.
   2. Use the import utility of your database program to load thedata from each file into the table of the same name. You willperform this step three times, once for each table.
3. Write basic queries against imported tables to organizeand analyze targeted data. For each query, include ascreenshot of the query and its output. You should also include abrief, 1- to 3-sentence description of the output.
   1. Write an SQL query that returns the count of orders forcustomers located only in the city of Framingham, Massachusetts.
      1. This query will use a table join between thecustomers and orders tables. The query will alsouse a where clause.
      2. How many records were returned?
   2. Write an SQL query to select all of the customers located inthe state of Massachusetts.
      1. Use a WHERE clause to limit the number of records in thecustomers table to only those who are located inMassachusetts.
      2. Record an answer to the following question: How many recordswere 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) Show transcribed image text 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)

Expert Answer

Answer to MYSQL rma.csv customers.csv orders.csv Import the data from each file into tables. Use the QuantigrationRMA database, th…