Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Open the two SQL files below in MySQL Workbench, then edit the statements in hw 6 . sql in accordance with the instructions. campaign -
Open the two SQL files below in MySQL Workbench, then edit the statements in hwsql in accordance with the instructions. campaignnormal.sql https:drivegoogle.comfiledunIzqLikPQGnVttUMnQBLMviewuspsharing hwsql The problems are based on the normalized CA candidate, contributor and contribution tables in file 'campaignnormal.sql; NOTE: this is a large file. It will be faster if you use the File Run Script function in the workbench rather than open the file and execute it 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 select ; 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 select ; 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. select ; 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. select ;
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