Good morning,
I am developing an application in ASP.NET MVC C # that calculates the overtime of an employee, I need to make a query that allows me to be able to bring the data of a table called MarcacionesBiometrico strong> which is where the data that is extracted from the biometric of the employee's bookings is stored, and compare that data with its schedule, the employee's schedule data is stored in a table called Schedule . And you can base the comparison knowing the extra hours that each employee and store them in a table called Extraordinary Time . Then I leave the relational diagram.
Thank you very much