The GROUP BY clause groups the data by the values of Jobcode. Thus,
any summary statistics are calculated for each grouping of rows by value of
Jobcode. The HAVING clause subsets the grouped data and returns rows for job
codes that contain an average age of greater than or equal to 30.

group by jobcode
having avgage ge 30;