1. Write SQL queries for these.
2. 1. Find the course names and percent scores for the courses that the student Amy Earhart took in her major. The query should return the student name, major, course name, and percent score. Order the results in decreasing order of percent score.

2. 2. Find the department from which the student Victoria Hanson has taken the most number of courses. The query should return student name, department, number of courses taken in that department. If two or more departments are tied for the highest number of courses, the result set should include all departments that are tied.

3. 3. Find the students to whom Professor Pat Kelliher gave a GPA of 0 or more considering all courses and all semesters. The query should return professor name, student name, course name, semester end date, and GPA. Order the results in increasing order of semester end date.

4. 4. Find for all the students the number of courses they have taken in their major and also in their minor. The query should return student name, major, minor, number of courses taken in major, number of courses taken in minor. Order the results in increasing order of student name.

5. 5. The percent score for the Principles of Marketing course that the student Bill Reilly took from Professor Mark DeLorean in Fall 2010 with a semester end date of 12/15/2010 was incorrectly recorded. The correct percent score is 82. Write a query to show what the incorrect score was. This query should return professor name, semester end date, course name, student name, and percent score. Place a GO separator after this query, and then write an UPDATE statement to correct the percent score to 82. Place a GO separator after the update statement, and then repeat the first query to display the corrected record.

Answer rating: 100% (QA)

Question 1 SELECT studentname major coursename percentscore FROM studentcourses WHERE studentname Amy Earhart ORDER BY percentscore DESC This query wi... View the full answer