Write your SQl statements in the areas provided below. You may also write on the

Question

Write your SQl statements in the areas provided below. You may also write on the back of this page, answering. 1) Below is the table information that needs to be concatenated using the CONCAT function. but be sure to indicate what question you are Result GridtFter Rows OH New York Washington D Cleves 43221 53707 10010 20006 45002 NY sed on the table above, write a CONCAT function that Concatenates customer_city, customer_state, and customer_zip as shown below. There is a comma and a space after customer_city. There is a space between customer_state and customer_zip: address Madison, WI 53707 Washington, DC 20120 -Write your answer in the box below: 2) Create one index on the customer_zip column of the customers table. Write your Create statement in the box below:

Explanation / Answer

1)
MySQL query that concatenates customer_ciyt,
customer_state and customer_zip on customers table

MySQL query:
SELECT CONCAT(customer_city,',',customer_state,' ',customer_zip)
FROM customers;

2)Creating an index on the customer_zip of customers table
MySQL query:
CREATE INDEX ONE customers(customer_zip);

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.