Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

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 After Mar 29, 2023

Solution

Pashikanti Sneha answered on Apr 05 2023
39 Votes
SELECT co
(s.AVG_CLASS_SIZE, g.TOTAL_GRADS_PERCENT_COHORT) as avg_class_size_co
elation FROM
GRADUATION 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