Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
col a heading "Average|Order $" format $999,999.99
col b heading "Maximum|Order $" format $99,999,999.99
col c heading "Minimum|Order $" format $999,999.99
col d heading "Number|of Orders" format 999
select avg(total) a, max(total) b, min(total) c, count(*) d
from s_ord
where date_ordered between to_date('01-AUG-92','dd-mon-rr') and to_date('30-SEP-92','dd-mon-rr')
/
Average Maximum Minimum Number
Order $ Order $ Order $ of Orders
------------ --------------- ------------ ---------
$129,905.75 $1,020,935.00 $377.00 16
1 row selected.
col a heading "Average|# Orders|Per Day" format 999
col b heading "Maximum|# Orders|Per Day" format 999
col c heading "Minimum|# Orders|Per Day" format 999
col d heading "Total|# Orders" format 999
select avg(cnt) a, max(cnt) b, min(cnt) c, sum(cnt) d
from (select count(*) cnt from s_ord group by date_ordered);
Average Maximum Minimum
# Orders # Orders # Orders Total
Per Day Per Day Per Day # Orders
-------- -------- -------- --------
2 5 1 16
1 row selected.
col a heading "Average|# Orders|Per Name" format 999
col b heading "Maximum|# Orders|Per Name" format 999
col c heading "Minimum|# Orders|Per Name" format 999
col d heading "Total|# Orders" format 999
col e heading "# of|Distinct|Names"
select avg(count(*)) a, max(count(*)) b, min(count(*)) c, sum(count(*)) d, count(*) e
from pits
where period between to_date('23-SEP-2004','dd-mon-yyyy') and
to_date('30-SEP-2004','dd-mon-yyyy')
group by name
/
Average Maximum Minimum # of
# Orders # Orders # Orders Total Distinct
Per Name Per Name Per Name # Orders Names
-------- -------- -------- -------- ----------
48 72 24 144 3
1 row selected