Home / Expert Answers / Computer Science / for-each-customer-find-the-34-most-favorite-34-product-which-the-customer-purchased-the-most-the-34-pa641

(Solved): For each customer, find the "most favorite" product (which the customer purchased the most), the " ...



For each customer, find the most favorite product (which the customer purchased the most), the least favorite product (whTable name is sales. Looking for \( S Q L \) query that will produce the similar output\#4.

For each customer, find the "most favorite" product (which the customer purchased the most), the "least favorite" product (which the customer purchased the least), the "most favorable state" (where the most amounts of purchases were made) and the "least favorable state" (where the least amounts of purchases were made). Table name is sales. Looking for \( S Q L \) query that will produce the similar output\#4.


We have an Answer from Expert

View Expert Answer

Expert Answer


Report #4 Query is as follows- SELECT sales.cust AS CUSTOMER,MAX(s1.prod)AS MOST_FAV_PRO
We have an Answer from Expert

Buy This Answer $5

Place Order

We Provide Services Across The Globe