Database Testing - Tutorial | SQL Complex Scenarios– Session 18
This video explains about the following scenario:
Identify the customer who have purchased same product maximum number of times.
Display identified customer details along with product details excluding other products purchased by the same customer.
Involves
1. Join with two level sub queries
2.nested aggregate function
3.group by and having.