Post reply

Pencentage

  • August 11, 2013 at 4:23 am

    #281830

    I have 3 tables:

    Student table

    (StudentNumber,Name,Contact,Address,DateOfBirth,YearEnrolled,Year Of Study)

    Absence table

    (SubjectCode,StudentNumber, DateOfAbsence)

    Subject table

    (SubjectCode, Subject Name,Description)

    I would need to display StudentNumber, Name, SubjectCode and the pecentatage of Date of Absence)taking that there are 10 lesson

    How can i disply the above.

  • August 11, 2013 at 2:10 pm

    #1640426

    You need to join the student table with the absence table, do a count on the absence date and divide this by 10.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply