Write an SQL query to insert four new records into the orders and customers tables using the following data Customers Table CustomerID FirstName LastName StreetAddress City State ZipCode Telephone 100004 Luke Skywalker 17 Maiden Lane New York NY 10222 212 555 1234 100005 Winston Smith 128 Sycamore Street Greensboro NC 27401 919 555 6623 100006 MaryAnne Jenkins 2 Coconut Way Jupiter FL 33458 321 555 8907 100007 Janet Williams 58 Redondo Beach Blvd Torrence CA 90501 310 555 5678 Orders Table OrderID CustomerID SKU Description 1204305 100004 ADV 24 10C Advanced Switch 10GigE Copper 24 port 1204306 100005 ADV 48 10F Advanced Switch 10 GigE Copper Fiber 44 port copper 4 port fiber 1204307 100006 ENT 24 10F Enterprise Switch 10GigE SFP 24 Port 1204308 100007 ENT 48 10F Enterprise Switch 10GigE SFP 48 port In the customers table, perform a query to count all records where the city is Woonsocket, Massachusetts How many records are in the customers table where the field city equals Woonsocket In the rma database, update a customers records Write an SQL statement to select the current fields of status and step for the record in the rma table with an orderid value of 5175 What are the current status and step Write an SQL statement to update the status and step for the orderid , 5175 to status Complete and step Credit Customer Account What are the updated status and step values for this record Provide a screenshot of your work Delete rma records Write an SQL statement to delete all records with a reason of Rejected How many records were deleted Provide a screenshot of your work Create an output file of the required query results Write an SQL statement to list the contents of the orders table and send the output to a file that has a csv extension 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) 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)

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 21, 2024

Write an SQL query to insert four new records into the orders and customers tables using the following data: Customers Table CustomerID FirstName LastName StreetAddress

Write an SQL query to insert four new records into the orders and customers tables using the following data:
Customers Table
CustomerID FirstName LastName StreetAddress City State ZipCode Telephone 100004 Luke Skywalker 17 Maiden Lane New York NY 10222 212-555-1234 100005 Winston Smith 128 Sycamore Street Greensboro NC 27401 919-555-6623 100006 MaryAnne Jenkins 2 Coconut Way Jupiter FL 33458 321-555-8907 100007 Janet Williams 58 Redondo Beach Blvd Torrence CA 90501 310-555-5678
Orders Table
OrderID CustomerID SKU Description 1204305 100004 ADV-24-10C Advanced Switch 10GigE Copper 24 port 1204306 100005 ADV-48-10F Advanced Switch 10 GigE Copper/Fiber 44 port copper 4 port fiber 1204307 100006 ENT-24-10F Enterprise Switch 10GigE SFP+ 24 Port 1204308 100007 ENT-48-10F Enterprise Switch 10GigE SFP+ 48 port
In the customers table, perform a query to count all records where the city is Woonsocket, Massachusetts.
1. How many records are in the customers table where the field city equals Woonsocket?
In the rma database, update a customers records.
1. Write an SQL statement to select the current fields of status and step for the record in the rma table with an orderid value of 5175.
  1. What are the current status and step?
2. Write an SQL statement to update the status and step for the orderid, 5175 to status = Complete and step = Credit Customer Account.
  1. What are the updated status and step values for this record? Provide a screenshot of your work.
Delete rma records.
1. Write an SQL statement to delete all records with a reason of Rejected.
  1. How many records were deleted? Provide a screenshot of your work.

Create an output file of the required query results. Write an SQL statement to list the contents of the orders table and send the output to a file that has a .csv extension.

image text in transcribed

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) 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)