need help with Python sql connectivity

I was given an assignment to create a python code using pymysql module on any database management system. I made the code but it has a lot of errors that I'm not able to fix. If anyone here could help me I'd be really grateful.