SQL HW helper

Questions Prepare a query that counts up the number of observations for each series by year Filter the above query to determine which series and years have 13 annual observations. How many series have 13 observations in any given year? Filter the above query to determine which series and years have less than 12 observations. How many series have less than 12 observations in a year? Determine which series have an annual average. Prepare a summary query that shows the series, series description, and the years that have an annual average. What data did you look into to determine what an annual average is? Build two new tables in your wrk schema: Using the AllSeries data filter out all annual records. Call this table [login to view URL] Using the AllSeries data filter out all monthly records. Call this table [login to view URL] Using the [login to view URL] table, Convert the period and year fields into a SQL date. Assume the date occurs at the end of each month (Hint, make sure you account for leap years and the length of each month. Call the new field SeriesDate.) Using the [login to view URL] table, Convert the period for year fields into a SQL date. Assume the date occurs at the end of each month (hint, make sure you account for leap years and the length of each month. For annual average records, make sure these values get treated as a NULL value. Call the new field SeriesDate. Which series IDs have seasonally adjusted data from 2000 to 2020 and involve the “business” industry? What SuperSectors are these series IDs part of? Prepare a summary table that summarizes the total employment from 2010 to 2020 for the “business” industry. Use seasonal adjusted values only. Using the above, prepare a table that summarizes the total amount of employment that falls into Professional and Business Services vs all other employment in the “business” industry? For Professional and business services that are part of the “business” industry, how many average hours do they work over this period? Compute the annual average by series ID and tell me if employees in this sector are working more or less over time and why? What proportion of Professional and Business Services is women compared to all employment for Professional and Business Services? Which series IDs have seasonally adjusted data from 2010 to 2020 and involve the “business” industry? Taking only “professional business” industries, build a summary table that shows the average, variance, std deviation of employment for all employees. Taking only “professional business” industries, build a summary table that shows the average, variance, std deviation of employment for women employees. Using a and b above build a ratio that shows the average % employment of the workforce between men and women. Compare the DataGoog file to the Series file Determine the number of unique series that are in the DataGoog table that are in the Series table Apply the label for the Series that are both the DataGoog and Series tables and display the min and max years for the series with the series labels Build a summary query that shows the number of series that are in both DataGoog and AllData, just in DataGoog, just in AllData. This query should be a summary table of no more than three rows of output. Compare the DataType table to the data type field in the Series table. Write a CASE statement to summarize the comparison into the following categories (Hint (Your output should have no more than 3 rows) In Data Type, Not in Series In Series, Not in Data Type Match Using #6, determine if any of the series that do not match are contained in the AllData table. List any series ID that do not match.