Task 4: Subqueries, Unions, Derived Tables, Oh My!

Write a query that returns the series_id, industry_code, industry_name, and value from the january_2017 table but only if that value is greater than the average value for annual_2016 of data_type_code 82.

Create a union table comparing average weekly earnings of production and nonsupervisory employees between annual_2016 and january_2017 using the data type 30. Round to the nearest penny. You should have a column for the average earnings and a column for the year, and the period.