I have a table which stores following details of courses done by the employees.

Employee No.
Course ID
Start Date
End Date
Certificate No.
Expiry

I need the following:

1. Total expiry dates less than Today's Date (Total employees due for a course)

2. Total expiry dates greater than Today's Date (Total employees which have valid course certificate)

3. Total empty expiry dates (Total employees to attend the course first time)

4. Create pie chart using these three totals.

OR

If there is any other alternate way to make the required pie chart.

Best regards,

Junaid