Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help with these SQL questions. 1 ) - - For each candidate, what decimal fraction of the number of positive contributions - -
I need help with these SQL questions. For each candidate, what decimal fraction of the number of positive contributions came from contributions $ The result should have a calculated labeled as "fraction" that is a subquery to calculate the sum of contributions over $ by candidate divided by the sum of all positive contributions for the candidate. Order by fraction in decreasing order. The result should include a row with Hillary Clinton with a fraction value For each contributor that made more than contributions, show the contributor name, total dollar amount contributed use label "total" and number of contributions use label "number" Order by descreasing number. List the last name, zip, and number of contributors with that last name and zip. Use output labels "lastname", "zip" and "number". Only list rows where number is greater than Use the substringindex function to extract the last name from the name column. Looking at only the first five digits of the zip code, show the zip codes with the highest number of contributors not contributions Show the fivedigit form of the zip code labeled as "zip" and the number of contributors labels as "count" Order by count high to low, and then zip low to high. The first result row should be What is the average number of contributions per zip code? Use only the first five digits of the zip code. Round the average to an integer and label it "average". The correct answer is Here is the Schema db table Please give correct answers. I will give like.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started