select ime,prezime,round(100*premija/plata,2),  case when (extract(month from datrodj)<extract(month from sysdate)) then 'prosao rodjendan' 
                                                 when (extract(month from datrodj)<extract(month from sysdate) and extract(day from datrodj) > extract(day from sysdate)) then 'prosao_rodjendan'
                                                else 'nije_prosao' 
                                                end as rodjendan
                                                
                                                
from zaposleni
where datzap + interval '16-6' year to month < sysdate;