SQL HW helper
Budget $30-250 USD
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
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.
8 freelancers are bidding on average $269 for this job
Senior SQL expert. I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating More
Hi there, I checked your requirements and guarantee you it's gonna be done within the next few hours. Let's contact via chat so that I can start work immediately.
Hi there! Happy to take a stab at this - I should be able to crack it pretty easily, and I might be available for SJ time at some point this week if discussion is needed.
GOOD IN DATABASE PROGRAMMING HELLO DEAR CLIENT I have gone through your project details, having all the required skills and VAST EXPERIENCE.I confirm to you that the project is doable since its within my area of EXPERT More
Hey! I am professional Swift computer programmer with skills including Database Administration, Oracle, SQL, Database Programming and Database Development. Please contact me to discuss more about this project. Thanks
Hello, there! How are you! I am a dbexpert. I've read your explanation carefully. I'm confident with your project. I can work right now. Please contact to me. Thank you! Looking forward to hearing from you. Thank you.
I'm studying computer engineering. I'm confident about sql. I believe I will do a good job for this task.