The SELECT clause specifies four columns for the view: Jobcode and three columns, Number, AVGAGE, and AVGSAL, whose values are the products of functions. COUNT returns the number of nonmissing values for each jobcode because the data are grouped by Jobcode. LABEL= assigns a label to the column. 
      select Jobcode,
             count(jobcode) as number label='Number',