import mysql.connector
 
mycon=mysql.connector.connect(
         host='localhost',
         user='root',
         password='password', 
         database='School')
 
if mycon.is_connected(): 
    print('Database connected')
 
cursor = mycon.cursor()
 
# Count the number of records in each stream and display it:
 
sql ='SELECT Stream, COUNT(*) FROM STUDENT GROUP BY      
          Stream'
cursor.execute(sql)
data = cursor.fetchall()
print("Answer for a):")
for rec in data:
      print(rec)
 
 
 
# Display the number of students who have secured 'A' Grade:
 
sql ="SELECT COUNT(*) FROM STUDENT WHERE Grade='A'"
cursor.execute(sql)
count = cursor.fetchone()[0]
print("The number of students with 'A' grade is {count}")
 
# Add a new column called Rank in the table:
 
sql ='ALTER TABLE STUDENT ADD Rank CHAR(3)'
cursor.execute(sql)
mycon.commit()
print('Field Added')
 
mycon.close()
 

aW1wb3J0IG15c3FsLmNvbm5lY3RvcgoKbXljb249bXlzcWwuY29ubmVjdG9yLmNvbm5lY3QoCiAgICAgICAgIGhvc3Q9J2xvY2FsaG9zdCcsCiAgICAgICAgIHVzZXI9J3Jvb3QnLAogICAgICAgICBwYXNzd29yZD0ncGFzc3dvcmQnLCAKICAgICAgICAgZGF0YWJhc2U9J1NjaG9vbCcpCgppZiBteWNvbi5pc19jb25uZWN0ZWQoKTogCiAgICBwcmludCgnRGF0YWJhc2UgY29ubmVjdGVkJykKCmN1cnNvciA9IG15Y29uLmN1cnNvcigpCgojIENvdW50IHRoZSBudW1iZXIgb2YgcmVjb3JkcyBpbiBlYWNoIHN0cmVhbSBhbmQgZGlzcGxheSBpdDoKCnNxbCA9J1NFTEVDVCBTdHJlYW0sIENPVU5UKCopIEZST00gU1RVREVOVCBHUk9VUCBCWSAgICAgIAogICAgICAgICAgU3RyZWFtJwpjdXJzb3IuZXhlY3V0ZShzcWwpCmRhdGEgPSBjdXJzb3IuZmV0Y2hhbGwoKQpwcmludCgiQW5zd2VyIGZvciBhKToiKQpmb3IgcmVjIGluIGRhdGE6CiAgICAgIHByaW50KHJlYykKCgoKIyBEaXNwbGF5IHRoZSBudW1iZXIgb2Ygc3R1ZGVudHMgd2hvIGhhdmUgc2VjdXJlZCAnQScgR3JhZGU6CgpzcWwgPSJTRUxFQ1QgQ09VTlQoKikgRlJPTSBTVFVERU5UIFdIRVJFIEdyYWRlPSdBJyIKY3Vyc29yLmV4ZWN1dGUoc3FsKQpjb3VudCA9IGN1cnNvci5mZXRjaG9uZSgpWzBdCnByaW50KCJUaGUgbnVtYmVyIG9mIHN0dWRlbnRzIHdpdGggJ0EnIGdyYWRlIGlzIHtjb3VudH0iKQoKIyBBZGQgYSBuZXcgY29sdW1uIGNhbGxlZCBSYW5rIGluIHRoZSB0YWJsZToKCnNxbCA9J0FMVEVSIFRBQkxFIFNUVURFTlQgQUREIFJhbmsgQ0hBUigzKScKY3Vyc29yLmV4ZWN1dGUoc3FsKQpteWNvbi5jb21taXQoKQpwcmludCgnRmllbGQgQWRkZWQnKQoKbXljb24uY2xvc2UoKQo=