I want to have attendance of all students in all courses displayed so that every row has student username, first name, course 1 attendance, course 2 attendance, course 3 attendance (total attendance "from" upto "to" date.
I have no knowledge of SQL. I went through several discussion forums and saw that many places this query was asked but there is no answer to that.
Please assume that an undergraduate student studying in a particular year may have from 9-10 courses and attendance in each course is needed to be shown in the report against the students name
Any clues will be really helpful. Thanks in advance.