SELECT e$.$empname, COUNT$(*)$ AS 'Days Exceeding Average'

FROM slsemp e

JOIN $($

SELECT empID, SalesDate, SUM$($Qty$)$ AS 'Total Quantity'

FROM slstrasx

GROUP BY empID, SalesDate

$)$ t ON e$.$empID $=$ t$.$empID

JOIN $($

SELECT AVG$($Qty$)$ AS 'Avg Quantity'

FROM slstranx

$)$ a

WHERE t$.$'Total Quantity' $>$ a$.$'Avg Quantity'

GROUP BY e$.$empname;