MySQL Question

I have provided the assignment instructions. Please review and answer all requirements. My professors name is Grimes, if my name is needed for the assignment please let me know.