[Closed] How to show the percent completion of each division in each course?

Hello everybody,

I am a new ASP.NET developer and I am working now on my first web-based application for my company. The applicaiton tracks the training courses which the employees took or attended them. I want to show a percent completion of each division in my department in each one of these courses. The courses are divided into three groups. I have the following database design:

Employee Table: Username, Name, DivisionCode
Division Table: DivisionCode, DivisionName
Course Table: CourseID, CourseName, GroupID
Group Table: GroupID, GroupName
Employee_Course Table: Username, CourseID

(The first attribure in each table is the primary key)

So how I can be able to show the percent completion for each division:

1. in all courses

2. in each group of courses

I need to two queries to show each one of the above requirements. So how to do that?