Question

5. construct a query to "show students who have a gpa between 3.25 and 4.0" results should be sorted by gpa in descending order

6. construct a query to "show students majoring in accounting or finance"

7. construct a query to "calculate the average gpa" for students

show fields: GPA

total row: Avg function

Answer 1

5.

Select * from Student where GPA between 3.25 and 4.0 order by GPA desc;

6.

Select * from Student where Major = 'Accounting' or Major = 'Finance';

7.

Select Avg(GPA) from Student;

Do ask if any doubt. Please upvote.