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
Get step-by-step solutions from verified subject matter experts
