I need sql code. I send major, instructors, student, grade_performance table photo because its not print.

MAJOR table

INSTRUCTOR

table

STUDENT table

GRADE_PERFORMANCE table

Please complete following exercises based on above tables. (5 points per exercise)

1. Please write down SQL select statement to generate and display results based on following criteria:

5 columns: student_id, student full name, major, advisor full name, and gpa

Display all students

Instructors are also students advisors

Sort data based on students major in alphabetical order

2. Please write down SQL select statement to generate and display results based on following criteria:

5 columns: student_id, student full name, major, gpa, and grade performance Display all non- web students.

Sort data based on students gpa from lowest to highest

3. Please write down SQL select statement to generate and display results based on following criteria:

3columns: major, number of student, and average of gpa Display all students.

Sort data based on students major in alphabetical order

4. Please write down SQL select statement to generate and display results based on following criteria:

5 columns: student initial, number of student, and average of gpa Display all students.

Sort data based on students initial in alphabetical order

5. Please write down SQL select statement to generate and display results based on following criteria:

5 columns: student initial, number of student, and average of gpa

Display all students with students last_name initial is either B, G, or F. Sort data based on average of gpa from lowest to highest

Pease cormplete owing eaecl based on above tables 15 points per esemhe