Query manager

Hi user,

I need to create a query from ps_job using query manager and

get  total employees, total active employess, total inactive employees taking a date range.

taking account hire_dt.

total employees most be < first date range  and Active and inactive within the date range.

  Avg= ((Total -Inactive +Active) + Total) /2 =((1000-50+70)+1000)/2 =1010 Rotacion

Rotation = ( (Active - Inactive)/Avg ) * 100       =(( 70-50)/1010) * 100  1.98 

Example:

                                                                                          

Total      Inactive    Active   Avg          Rotacion

1000      50           70         1010        1.98

just have access to query manager 4  tier, no access to application designer.