SQL HW helper

Cerrado Publicado hace un año Pagado a la entrega
Cerrado Pagado a la entrega

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.

SQL Administración de bases de datos Programación de bases de datos Oracle Desarrollo de base de datos

Nº del proyecto: #35808318

Sobre el proyecto

7 propuestas Proyecto remoto Activo hace un año

7 freelancers están ofertando un promedio de $288 por este trabajo

merinsinha

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 Más

$200 USD en 3 días
(26 comentarios)
3.9
esa59cfdec1d6569

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.

$40 USD en 7 días
(7 comentarios)
2.9
oba2311

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.

$100 USD en 7 días
(1 comentario)
0.5
tkmaina868

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

$100 USD en 3 días
(0 comentarios)
0.0
yevhenrosovskii

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.

$1400 USD en 7 días
(0 comentarios)
0.0
gemmadu

Hi! I would be glad to help you with these queries. I have 6 years of Oracle database testing with a last year off. Your project seems like a perfect way to refresh my skills, so I’m ready to take it for a smaller paym Más

$35 USD en 4 días
(0 comentarios)
0.0
gulserenslh

I'm studying computer engineering. I'm confident about sql. I believe I will do a good job for this task.

$140 USD en 7 días
(0 comentarios)
0.0