QUESTION

Employee and Monthly expenses

Hand

$2.$

$\frac{0}{60}$

Write a SQL query to find the names of employees and the total amount they have spent on expenses. Include only those employees who have spent more than the average of total spending of employees who have recorded expenses in at least three different months

Order by name in ascending order.

Tables Schema as Below:

$\backslash$table$[[$Employees$],[$columnName$,$dataType$],[$EmployeelD$,$int$],[$Name$,$varchar$(255)],[$Expenses$,],[$columnName$,$dataType$],[$ExpenselD$,$int$],[$EmployeelD$,$int$],[$ExpenseDate$,$date$],[$Amount$,$decimal$(10,2)]]$