Project 2

MY SQL Project 2

Akshay Umakant Bandewar

Q.4 Display first 1000 rows of tables (College_A_HS, College_A_SE, College_A_SJ, College_B_HS, College_B_SE, College_B_SJ) with Python.

College_A_HS

College_A_SE

College_A_SJ

College_B_HS

College_B_SE

College_B_SJ

Q.5 Import first 1500 rows of tables (College_A_HS, College_A_SE, College_A_SJ, College_B_HS, College_B_SE, College_B_SJ) into MS Excel.

College_A_HS

College_A_SE

College_A_SJ

College_B_HS

College_B_SE

College_B_SJ

Q.13 Import the created views (College_A_HS_V, College_A_SE_V, College_A_SJ_V, College_B_HS_V, College_B_SE_V, College_B_SJ_V) into MS Excel and make pivot chart for location of Alumni.

College_A_HS_V

College_A_SE_V

College_A_SJ_V

College_B_HS_V

College_B_SE_V

College_B_SJ_V