hey i changed ma table structure. now how should the querry be written.thank you in advance.

Employee (EmployeeID,Name,Salary,Tpye)

TestEmployee(TestNo,EmployeeID,Hrs)

Test(TestNo,TestDate,Result)

hey the issue is question specifically says to use a DATABASE TRIGGER to solve it 🙁