I have something to do and maybe there is somebody out there having a better solution.

I have a table like that :

JOB# TICKET# CLIENT# DONE
1 1 1 yes
1 2 1 no
1 3 1 yes
2 1 2 yes
2 2 2 yes
3 1 3 yes
3 2 3 no

I need a SQL select (or some other solution) to produce the following
cursor :

JOB# PROGRESS(%)
1 66%
2 100%
3 50%

So, the SQL result must have 1 record for each JOB# value and the second column is defined as :

100 * (How_Many_records_with_DONE=YES / How_Many_records

If you have any decent solution for that please let me know. This
cursor have to be updated every 10 seconds and there are milions
of records in the main table.