596_____________________________________________ 10

     Dimensions  . 
 ,         -
,    .        -
,       Dimensions.      -
     ,   
. 10.15.

  Summaries     , 
         ,
  .     Count(*) for Avera-
ges     (Count)   .   
    , , .   
     .   -
    Year_b         Sum-
maries.        : sum  ,
count    average  .  average.    Summari-
es     AVG(YEAR_B), a SUM(YEAR_B)    -
.       ,  
  .

  SQL Query (. 10.16)     SQL, 
    .       :

SELECT DEP, SEX, YEAR_B, COUNT( * ) COUNTALL, SUM( YEAR_B )

FROM PERS

GROUP BY DEP, SEX, YEAR_B

      SELECT    (Dep,
Sex, Year_b),    .    -
   GROUP BY.      
,  ,     ,   
   SELECT.       -
,    Edit Query,     -
.      Edit Query   Edit Done.  -
     ,    
,       ,   - -
 .  Edit Cancel   .

   . 10.15  10.16    Query Builder.  -
     SQL,     -
 .        -

. 10.16

 SQL Query  
 Decision Cube