Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I am in need of assistance in solving these problems. I have attached a self made interactive spreadsheet (forgive me if its not up to
I am in need of assistance in solving these problems. I have attached a self made interactive spreadsheet (forgive me if its not up to par, I don't know what I'm doing in excel) of the tables in the pictures below if that will better assist you.
Thank you! Apparently MYSQL is required for this assignment.
Link to the tables --- > https://docs.google.com/spreadsheets/d/10KZDIZKU60TVV6_jZ-F_zLIQNWRXYaae/edit?usp=sharing&ouid=118131953765831184085&rtpof=true&sd=true
NOTE: MYSQL is required for this assignment. Paul Bunyan is the owner of a wooden toy distributor named Blue Ox Distribution. Examine the tables below and their sample data. NOTE: Bolded column names represent primary key field(s). REPS table: REP_NUM LAST_NAME FIRST_NAME STREET 724 Vinca Dr. 632 Liatris St. 1785 Tyler Ave. 267 Oakley St. Congaree CA 15 30 45 60 CITY STATE ZIP_CODE COMM_RATE Grove CA 90092 Fullton 90035 Northfield CA 90098 CA 90097 Campos Rafael Gradey Megan Tian Hui Sefton Janet 0.06 0.08 0.06 0.06
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