For database im having a hard time with my code $,$ What is the average sale amount for each sale reps in each office. Null should be ignored

SELECT salesrep, office, AVG$($sale$)$ AS avg$\_$sale

FROM orders

WHERE sale IS NOT NULL

GROUP BY salesrep, office;

$$ For each salesrep that has made an order, list the minimum, maximum and average order amount for all their orders. Include only those orders made anytime from $2020-2021.$ Omit from the list any salesrep that has only made $1$ order in this time frame. Sort the results by Empl$\_$Num.

SELECT empl$\_$num, MIN$($amount$)$ AS MinAmount, MAX$($amount$)$ AS MaxAmount, AVG$($amount$)$ AS AvgAmount

FROM orders

WHERE order$\_$date $>=\text{'}2020-01-01\text{'}$ AND order$\_$date $<\text{'}2022-01-01\text{'}$

GROUP BY empl$\_$num

HAVING COUNT$(*)>1$

ORDER BY empl$\_$num;