One salesman Nick is selling in 50 shops..and Other salesman Tom is selling in different 80 shops so top 3 shop sales of both the salesman need with amount in single line
Suppose Nick sold in 50 shops and out of top 50 his Top 3 shop sales is -
Shop code A1234 sales is 12 dollar
Shop code A1235 sales is 100 dollar
Shop code A1236 sales is 150 dollar
I need top 3 so sales will be
Output-
Employe Name Top3_Shop_Sales
** Nick 262 **
** Tom 536**