Challenge

SQL-PROJECT-2

KKotyada Bhavani Gayatri13 Oct 2022

2.Import all .csv files into MySQL

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.

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.

ANS:-College_A_HS

College_A_SE

College_A_SJ

College_B_HS

College_B_SE

College_B_SJ

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.

ANS:-College_A_HS_V

College_A_SE_V

College_A_SJ_V

College_B_HS_V

College_B_SE_V

College_B_SJ_V

SQL-PROJECT-2

Ship work like this
in your own course.

Talk to a career counsellor

Ship work like thisin your own course.

Talk to a career counsellor

Ship work like this
in your own course.