Construct an SQL Query for the following Salesperson Colin recently had an encounter with a customer who he would like to contact again Unfortunately, Colin cant remember if the customers last name was Hansen or Hanson Construct a query to help Colin find the correct customer to follow up with Show the customers first name, last name, and phone number Customer Encounter CreditRating 7 CreditID CreditDescription MinFICO MaxFICO Comments Customer CFirstName CLastName CPhone AnnualIncome CreditID EncID SalesID Customer EncDate Purchase Sales Person Y SalesID SFirstName SlastName SHireDate Salary

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

Question: Construct an SQL Query for the following: Salesperson Colin recently had an encounter with a customer who he would like to contact again. Unfortunately, Colin

Construct an SQL Query for the following:
Salesperson Colin recently had an encounter with a customer who he would like to contact again. Unfortunately, Colin cant remember if the customers last name was Hansen or Hanson. Construct a query to help Colin find the correct customer to follow up with. Show the customers first name, last name, and phone number.

Customer Encounter CreditRating 7 CreditID CreditDescription MinFICO MaxFICO Comments * Customer CFirstName CLastName CPhone AnnualIncome CreditID * EncID SalesID Customer EncDate Purchase Sales Person Y SalesID SFirstName SlastName SHireDate Salary

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Your job is to create the 10 queries listed below and answer questions about each query to verify whether you created it correctly. Notice that each quix question (found after the entire list of...

A % Conditional Formatting Format as Tablo v Paste Font Alignment Number Cells Cell Styles Editing ES x vfx 56000 C D E F G . 1 OWN Salesid SFirstName SlastName SHireDate Salary 1 Harry Potter...

Your job is to create the 10 queries listed below and answer questions about each query to verify whether you created it correctly. Notice that each quiz question (found after the entire list of...

I need awnsers for query 2 please. 1. Generate a list of salespeople and sort it in descending order by hire date. Show the first name, last name, hire date, and salary for each salesperson. 2....

Generate a list of customers with annual incomes greater than $80,000 who purchased cars from salesperson Katie. Show the first name, last name, and annual income of each of these customers. Which...

I don't know how to make it as SQL Which customers purchased vehicles from salesperson Dudley despite having a Poor, Very Poor, or Extremely Poor credit rating? Show the first name, last name, and...

Generate a list of salespeople sorted descending by hire date. Show the first name, last name, hire date, and salary for each salesperson. Generate a list of customers whose last name begins with the...

5. Salesperson Colin recently had an encounter with a customer who he would like t contact again. Unfortunately, Colin can't remember if the customer's last name was "Hansen" or "Hanson." Construct a...

Salesperson Colin recently had an encounter with a customer who he would like to contact again. Unfortunately, Colin can t remember if the customer s last name was Hansen or Hanson . Construct a...

What is the role of the team leader? Should teams always have leaders? When might it be reasonable for a team to purposely leave out the role of team leader?

Describe the services provided by a credit reporting service such as Experian, Equifax, and TransUnion. How are these services provided?

EXERCISE 3-10. Costing Units Completed and Ending Work in Process For the month of September, Wilber Pickle Company had cost per equivalent unit of $0.50 for materials (pickles, vinegar, spices,...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

8. Do you believe that others can compete but that they also can choose to cooperate? __ always __ usually __ occasionally __ seldom __ never true?

3. Would you say that effective teamwork saved their lives?

6. Do you believe that differences of opinion are helpful and beneficial? __ always __ usually __ occasionally __ seldom __ never true