import  mysql.connector
 
mycon= mysql.connector.connect(
            host='localhost',
            user='root',
            password='password',
            database='School')
 
# Display all the records of students who are in the Medical stream:
 
if  mycon.is_connected():
      print('Database connected')
cursor = mycon.cursor()
sql ="SELECT * FROM STUDENT WHERE Stream='Medical' "
cursor.execute(sql)
records = cursor.fetchall()
print("Answer for a):")
for rec in records:
print(rec)
 
# Change the Class of Divakar to 12C:
 
sql ="UPDATE STUDENT SET Class='12C' WHERE Name='Divakar'"
cursor.execute(sql)
mycon.commit()
print("Record Updated")
 
# Display the maximum mark of students in class 12:
 
sql ="SELECT MAX(AvgMark) FROM STUDENT WHERE Class='12'"
cursor.execute(sql)
max_mark = cursor.fetchone()[0]
print("Answer for c):")
print("The maximum mark in class 12 is:{max_mark}")
 
mycon.close()
 

aW1wb3J0ICBteXNxbC5jb25uZWN0b3IKCm15Y29uPSBteXNxbC5jb25uZWN0b3IuY29ubmVjdCgKICAgICAgICAgICAgaG9zdD0nbG9jYWxob3N0JywKICAgICAgICAgICAgdXNlcj0ncm9vdCcsCiAgICAgICAgICAgIHBhc3N3b3JkPSdwYXNzd29yZCcsCiAgICAgICAgICAgIGRhdGFiYXNlPSdTY2hvb2wnKQogICAgICAgICAgICAKIyBEaXNwbGF5IGFsbCB0aGUgcmVjb3JkcyBvZiBzdHVkZW50cyB3aG8gYXJlIGluIHRoZSBNZWRpY2FsIHN0cmVhbToKCmlmICBteWNvbi5pc19jb25uZWN0ZWQoKToKICAgICAgcHJpbnQoJ0RhdGFiYXNlIGNvbm5lY3RlZCcpCmN1cnNvciA9IG15Y29uLmN1cnNvcigpCnNxbCA9IlNFTEVDVCAqIEZST00gU1RVREVOVCBXSEVSRSBTdHJlYW09J01lZGljYWwnICIKY3Vyc29yLmV4ZWN1dGUoc3FsKQpyZWNvcmRzID0gY3Vyc29yLmZldGNoYWxsKCkKcHJpbnQoIkFuc3dlciBmb3IgYSk6IikKZm9yIHJlYyBpbiByZWNvcmRzOgpwcmludChyZWMpCgojIENoYW5nZSB0aGUgQ2xhc3Mgb2YgRGl2YWthciB0byAxMkM6CgpzcWwgPSJVUERBVEUgU1RVREVOVCBTRVQgQ2xhc3M9JzEyQycgV0hFUkUgTmFtZT0nRGl2YWthciciCmN1cnNvci5leGVjdXRlKHNxbCkKbXljb24uY29tbWl0KCkKcHJpbnQoIlJlY29yZCBVcGRhdGVkIikKCiMgRGlzcGxheSB0aGUgbWF4aW11bSBtYXJrIG9mIHN0dWRlbnRzIGluIGNsYXNzIDEyOgoKc3FsID0iU0VMRUNUIE1BWChBdmdNYXJrKSBGUk9NIFNUVURFTlQgV0hFUkUgQ2xhc3M9JzEyJyIKY3Vyc29yLmV4ZWN1dGUoc3FsKQptYXhfbWFyayA9IGN1cnNvci5mZXRjaG9uZSgpWzBdCnByaW50KCJBbnN3ZXIgZm9yIGMpOiIpCnByaW50KCJUaGUgbWF4aW11bSBtYXJrIGluIGNsYXNzIDEyIGlzOnttYXhfbWFya30iKQoKbXljb24uY2xvc2UoKQo=