Question: 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
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
