contestada

what are the names of customers who have bought products with a current list price of over $60 made by manufacturers in new jersey? show first and last names

Respuesta :

The names of customers Select distinct FirstName ,LastNamefrom Customer Cjoin Sale S on C.CustomerID = S.CustomerID Join SaleItem SI on S.SaleID = SI.SaleID join Product P on SI.ProductID = P.ProductID join Manufacturer M on P.ManufacturerID = M.ManufacturerID where ListPrice > 60and M.State = 'NJ'.

A customer is an individual or company that purchases goods or services from another company. Customers are very important because they generate revenue. Without them, companies would go bankrupt.

A customer is generally defined as someone who purchases goods, products, or services. More specifically, a customer is a person or company who is currently purchasing, may have purchased, or be interested in products or services from another person or company.

A customer need is a need that motivates a customer to purchase a product or service. The need may or may not be known (that is, the customer can verbalize it) and is an important factor in deciding which solution the customer will purchase.

Learn more about customer https://brainly.com/question/26313265

#SPJ4