I need help for SQL Code.please send me answer1, 2, 3 means some direcction not all joint..

1. Major Table:

Major Major_Name

CSC Computer Science

DBA Database Managment

WEB Web Design

GRD Gamming Design

NET Networking

2. INSTRUCTOR table

Instructor_ID Last_name First_Name Job_title

101 Evans Mary Instructor

102 Fargo Julie Instructor

103 Foster Jack Assistant Professor

104 Halliday John Assistant Professor

105 Enkema Jennifer associated Professor

106 Mills Jennife associated professor

107 Parks peter Proffesor

108 paul Mike Proffesor

109 Rosen Ann Proffesor

110 williams Jeans Senior Proffessor

111 williams Jerry Senior Proffessor

3. STUDENT TABLE

Student_Id Last_name First_name Major Advisor_Id GPA

10001 White John DBA 101 3.50

10002 Black Jack DBA 107 3.75

10003 Brown Jone DBA 102 4.00

10004 Gray Jennifer DBA 106 4.00

10005 Blue July CSC 102 2.80

10006 Smiths Julie CSC 101 2.50

10007 Green Jack CSC 105 3.00

10008 Miller Robert CSC 104 3.65

10009 Ford Allen CSC 111 3.85

10010 Jordan Michael WEB 107 4.00

10011 Lin Jennifer WEB 109 4.00

10012 Chen Jackie WEB 108 3.50

10013 Li Jack WEB 109 3.25

10014 Lopez Jennifer WEB 111 4.00

4. GRADE_PERFORMANCE table

Performance Lo_Grade Hi_Grade

poor 1.00 2.00

Low 2.01 2.50

Average 2.51 3.00

Good 3.01 3.50

Excellent 3.51 3.75

Great 3.76 4.00

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