How do I code a monthly attendance report in SQL?

Asked By 60 points N/A Posted on -
qa-featured

Hallo Guys! I am looking for a code that is capable of querying database generating a monthly attendance report in SQL. The code should be such that it adds the number of days that someone has attended. Comment on whether this code can be expanded to include fingerprint recognition to enable verification of persons. Cheers.

SHARE
Answered By 50 points N/A #131881

How do I code a monthly attendance report in SQL?

qa-featured

You can first add the columns or rows using SUM then you can either subtract that with 28 or 29 for the month of February, and 30 or 31 for the other months of the year. You may also select the records before adding by month if there is a 'months' column in your database. After selecting, you may add the records. You can research more about SUM query from different websites like w3schools or at StackOverflow.

Login/Register to Answer

Related Questions