Question

STUDENT(StudentID, First_name, Last_name, email, PhoneNo, BirthDate, Major, GPA); Which of the following queries would display names and GPA of all students sorted by major, and then ordered by GPA? a. Select First_name, Last name, Major, GPA from Student order by Major, GPA; b. Select First_name, Last name, Major, GPA order by GPA DESC from Student; c. Select First_name, Last name, GPA from students order by GPA DESC; d. Select First_name, Last name, GPA from Student order by GPA, Major;

Answer 1

Answer:

Kindly note that, you're to replace "at" with shift 2 as the brainly text editor can't accept the symbol

Explanation:

TABLE SCHEMA

create table STUDENT(StudentID int,

Answer 2

Answer:

Select First_name, Last_name, Major, GPA from Student order by Major, GPA;

Explanation:

Select First_name, Last_name, Major, GPA from Student order by Major, GPA;

The above querry will produce or display names and GPA of all students sorted by major, and then ordered by GPA.