select work_country country, sum(sal) salaries
from wwv_demo_emp
group by work_country
order by 2 desc

select 'f?p=4600:32:'||:app_session||':::RIR:IR_JOB:'||job link, 
         job, 
        count(*) employees 
from wwv_demo_emp 
group by job 
order by 1

select ename||' - '||work_city||', '||work_country n, hiredate, empno
from wwv_demo_emp
order by 2 desc

SELECT 
      sum(case when COMM is null
                     then 0
                when COMM = 0
                     then 0
                else 1
                end) value,
       count(*) max_value
FROM   wwv_demo_emp

declare
  l_comm number;
  l_emp_count number;
  l_style             varchar2(1000) :=
'<style type="text/css" media="all">
div.progress_bar {
	margin: 10px;
}
span.progress_bar {
	width: 100%;
	border: 2px solid #666;
	height: 80px;
	display: block;
	-moz-border-radius: 20px;
	-webkit-border-radius: 20px;
	background-color: #FFF;
	position: relative;
}
span.progress_bar strong {
	position: absolute;
	display: block;
	text-align: center;
	width: 100%;
	font: 48px/80px normal Arial, sans-serif;
	color: #000;
	}
span.progress_bar span {
	background-color: #FFAA2B;
	display: block;
	height: 80px;
	-moz-border-radius: 18px;
	-webkit-border-radius: 18px;
}
</style>';
begin
sys.htp.p(l_style);
sys.htp.p('<br />');
select count(*), sum(decode(Work_Country,'United States',0,1))
   into l_emp_count, l_comm
from wwv_demo_emp;

sys.htp.prn('<center>'||
     sys.htf.escape_sc(
         wwv_flow_lang.system_message('PNONUS'))||
     '</center>');
sys.htp.prn('<div class="progress_bar">'||
     '<a href="f?p=4600:32:'||:app_session||':::RIR:IRNEQ_COUNTRY:United+States">'||
     '<span class="progress_bar"><strong>'||
     to_char(nvl((l_comm / l_emp_count),0)*100,'999')||'%</strong><span style="width:'||
     to_char(nvl((l_comm / l_emp_count),0)*100,'999')||'%">'||
     '</span></a></span></div>');
end;