I have a chart of monthly sales per employee. with the following query
SELECT
MONTHNAME (SaleDate) AS Month,
COUNT (*) AS sales,
Employee,
SaleDate,
FROM sales
WHERE (month (SaleDate) = month (now ()))
GROUP BY Employee
ORDER BY level DESC
this way can only see sales for the current month, as I can select the month. For example sales in November.