Question 28 (2 points) Consider the following table which represents students at TAMUC. Student ID 1 2 3 4 FName LName Major GPA Joe Black Marketing 4 Steve Jobs Accounting 3 Sarah McDonald Accounting 2 Michelle Hearth Marketing 2.5 State City TX Dallas CA San Jose TX Rockwall CA San Jose Write a SQL statement to show the number of students based on their major. A/ Question 29 (2 points) Consider the following table which represents students at TAMUC. Student ID 1 2 3 4 FName LName Major GPA Joe Black Marketing 4 Steve Jobs Accounting 3 Sarah McDonald Accounting 2 Michelle Hearth Marketing 2.5 State City TX Dallas CA San Jose TX Rockwall CA San Jose Joe has decided to drop out from school. Please remove this student from the table. A/