Question: You are working on a customer appreciation program. You'd like to generate a list of customer contact fields: i.e. First Name, Last Name. To recognize

You are working on a customer appreciation program.

You'd like to generate a list of customer contact fields: i.e. First Name, Last Name. To recognize the top customers, you only are generating the list for customer contacts that have generated more than 18 orders.

HINT: Integrate the subquery the WHERE clause

Example:

select field1, field2

from

table2

WHERE

(select count(*) from table1, where condition)

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 Mathematics Questions!