Often in your future jobs, you will asked a question by a person who is not totally sure what they want as an answer, or at least don't know the data/technical difficulties in obtaining one. Your job...

2 answer below »



Often in your future jobs, you will asked a question by a person who is not totally sure what they want as an answer, or at least don't know the data/technical difficulties in obtaining one. Your job is to not only find an answer, but to briefly explain the caveats of what was possible to conclude. This lab asks you to do both.











Your gruff boss walks into your office. "Somebody told me that graduation rates are all about demographic factors. I think they're about class size. Find out for me who is right."









There are four data files attached to help you investigate this question. While I'm not telling you exactly how to go about it, I would like you to index the variables you find appropriate. Hand in both a one paragraph explanation to your boss and your SQL file. You may ask me clarifying questions in class.




I have files but they were too much data to upload here.

Answered 6 days AfterMar 29, 2023

Answer To: Often in your future jobs, you will asked a question by a person who is not totally sure what they...

Pashikanti Sneha answered on Apr 05 2023
37 Votes
SELECT corr(s.AVG_CLASS_SIZE, g.TOTAL_GRADS_PERCENT_COHORT) as avg_class_size_correlation FROM
G
RADUATION g
JOIN high_school h on g.dbn = h.dbn
JOIN zipborough z on z.zip = h.postcode
JOIN SUMMARY s ON s.borough = z.borough
WHERE
g.TOTAL_GRADS_PERCENT_COHORT <> 's'
AND s.AVG_CLASS_SIZE IS NOT NULL;
...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here