        ____________549

       ,   -
, ,   :

SELECT Fam AS , 1999-Year_b AS  FROM Pers ORDER BY
 DESC

    ORDER BY   ,   
           . -
,        
   .. , 

SELECT Dep, Fam, Year_b FROM Pers ORDER BY Dep, Fam

      (  Dep),   -
    . 

SELECT Dep, Fam, Year_b, Sex FROM Pers ORDER BY Dep, Sex, Fam
   ,   . 

SELECT Fam as , 1999-Year b as , Sex as 
FROM Pers ORDER BY , 

      .

   Select      
DISTINCT  ALL.    ,     
   .    , 
   ,     Select.
  ALL    .   
,         .  
 DISTINCT. 

SELECT DISTINCT Dep FROM Pers

  ,    .

         ||,
  . ,     -
  :

SELECT DISTINCT ": " I I Dep FROM Pers

           -
,   :

: 

       ,  
, , , ,     Cast, -
      . ,  

SELECT Fam, "..: " || Cast(Year_b AS CHAR(4)) FROM Pers

 Cast     Year_b    
.     :

         .     ..: 1950

10.1.2.2  

 Select       ,
    () ,  
     .   ,  
 , <> )     ,
  . , 

SELECT count(*) FROM Pers