Q.1) (25 points) Use the ex database for this question. Write a query that repli

Question

Q.1) (25 points) Use the ex database for this question. Write a query that replicates the result set below, matching all data and format aspects, including column headers:

Tables | | active invoices color-sample Customers G] Columns customer_id customer last name customer first name customeraddress - customer-city customer state customer-zip customer-phone Indexes Foreign Keys > ] Triggers date-sample departments float-sample paid-invoices string-sample Stored Procedures employees null_sample projects Views Functions

Explanation / Answer

select customer_first_name +' '+ customer_last_name as

customer_name, customer_address, customer_phone from

customers;

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

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