How to select the employee who made the most sales
<p>I'm having trouble with this question in my Database homework.</p>

<p>I need to answer this question:</p>

<blockquote>
  <p>Select the name of the Employee and the email address for the employee
  that has the highest individual sale for the current month.</p>
</blockquote>

<p>So I basically need to select the employee with the most sales for the current month.</p>

<p>And here's what I have:</p>

<pre><code>SELECT 
    FirstName + ' ' + LastName as 'Employee Name', Email 
FROM 
    Employee 
INNER JOIN 
    Sale ON Employee.EmployeeNumber = Sale.EmployeeNumber
GROUP BY 
    Sale.SaleDate, Sale.SaleNumber, Employee.FirstName, Employee.LastName, Employee.Email
HAVING 
    DatePart(Month, SaleDate) = DatePart(Month, GetDate()) AND ...
</code></pre>

<p>The only thing I'm missing is the second part of my <code>HAVING</code> statement.</p>

<p>The query I currently have returns these <a href="https://i.stack.imgur.com/TTKlJ.png" rel="nofollow noreferrer">current query results</a></p>

<p>These results show me all sales made in the current month (November), we can see that Tom Tucker has the most sales. However, I need my select query to display his name only legitimately. (So without using WHERE (FirstName + LastName) = 'TomTucker') </p>

<p>I originally thought of using Max(Count(SaleNumber)) however I get an error saying I can't use aggregate functions within each other. So I have no clue how to get the result I want.</p>