The following question refers to this table. Stu_Reg …
The following question refers to this table. Stu_Reg stuID stuFName StuLName courseName majorCode majorDesc 1 John Chesson Database ISDS Information Systems and Decision Sciences 2 Kevin Adams Database ISDS Information Systems and Decision Sciences 3 Jamie Spearman Statistics ACCT Accounting Referring to the table above, which of the following describes a deletion anomaly?
Read Details22. How many colleges have received applications? (4 points)…
22. How many colleges have received applications? (4 points) 23. Report the name and GPA of students with a GPA greater than 3.5. List the results by GPA from highest to lowest. (4 points) 24. Please help LSU find the names of admitted students. (4 points) 25. For each college, report the college’s name and number of applications (rename as NumOfApp) from students with a GPA of 3.0 or above. (4 points) 26. Report the majors applied to by all students who attended a high school with fewer than 1,000 students. Do not use a nested query. Eliminate duplicate results. (4 points)
Read Details