Create a query that will show the name of each customer and their phone number f

ID: 3733091 • Letter: C

Question

Create a query that will show the name of each customer and their phone number for all customers who live in Clinton Township. Make sure the first and last name of the customer appears as one column. Additionally make sure your query accommodates for the multiple spellings of Clinton Township.

My output looked like the following:

Customer Name phone

------------------------------- ------------

Theodore Turner 586-555-9876

Patricia Jones 586-555-9876

Paul Jones 586-555-9876

Simon Tara NULL

Tara Roswell NULL

Haylee Higgins NULL

Explanation / Answer

Select CONCAT (First Name, ' ', Last Name) as Customer Name, phone

From Customer

Where city = 'Clinton Township' or city = 'clinton Township' or city = 'Clinton township';

Navigate

Create a query that will replace the null for termdate in the workers table with

Create a query to display the last name and salary for all employees. Format the

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

Create a query that will show the name of each customer and their phone number f

Question

Explanation / Answer

Related Questions

Navigate