Into Statement  «Prev  Next»

SQL INTO clause - Exercise

Using the INTO clause

Objective: Create a statement that will move a filtered cross-section of information from Customer Table to AZ_Customers Table.
Given the following table, named Customer:
Lastname Firstname PhoneNumber ZIP Code State
Wynsoup Stephen 520-555-1212 85744 AZ
Brennan Jeffrey 123-321-5678 04325 CA
Caitlin Elizabeth 444-231-5642 95439 WA
Wynsoup Julie 201-453-7641 85744 AZ
Andrews Julie 309-123-4567 85744 AZ

Create a statement that will make a copy of rows that represent Arizona (state code is AZ) and place them in a new table, AZ_Customers. When you are done, submit your statement .