How to write a query that is an employee who has the highest sales to the customer who has made the most purchases.In Sql Server : I'm having trouble with this question in my Database homework And need to answer this question:

**Which employee has the highest sales to the customer who has made the most purchases?**

And these are my database tables
[![enter image description here][1]][1]


  [1]: https://i.stack.imgur.com/HujP6.png

Please, help me to write this Query.