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.
count(jobcode) as number label='Number',