Question: Underlined Names signify the Primary Key for that table. We want to know the list of Customers who have not purchased any expensive products (i.e.,

 Underlined Names signify the Primary Key for that table. We want

Underlined Names signify the Primary Key for that table.

We want to know the list of Customers who have not purchased any expensive products (i.e., products whose average Price is 2000 or more.)

Write an SQL query that, for every such customer who has never purchased an expensive product, returns the CustomerId, FirstName and PhoneNumber. Return the results in the ascending order of CustomerId.

Consider the following database schema for a mobile phone store

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!