How to make a difficult sample?

Question

MySQL

Hello, I'm a beginner tester, I was given a task in the courses to make a selection from the database.
You need to select employees (employees) (this is the first column), and select the number of orders they have made (Orders).
Can you help me please?
PS I have not worked in IT before, I hope for your understanding

. The result should look like this:


Database structure: