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

Transcribed Image Text:

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 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