[Solved] database view creation issue

You should join two tables using ‘inner join’ and you have to use a ‘where’ condition. In where condition use ‘AND’ to check its the same person using the employee id and then sum the total working hours.