Write the SQL code and provide the results for the following inquiries.

• Return a list of the following
  • all student ids, student names, majors
  • student ids, section identifier, and grade for any student that enrolled in section identifier 112 or 119 or 135
  • the course_number, section_identifier, and instructor for all course taught by Anderson
  • Course_name, course_number, and credit_hours for all courses taught in 08.
• Add the following instances to their respective tables
  • Student table

Name: Kingston

Student number: 103

Class: 3

Major: EE

Name: Stark

Student number: 183

Class: 3

Major: CS

Name: Lyon

Student number: 228

Class: 1

Major: CS

Name: Riley

Student number: 48

Class: 2

Major: ME

• Course

Course_name: Java Programming

Course_number: CS0221

Credit_hours: 3

Department: CS

Course_name: DataBase Management Systems

Course_number: CS0404

Credit_hours: 3

Department: CS

Course_name: Computer Networking

Course_number: CS0402

Credit_hours: 3

Department: CS

Course_name: Linear Programming

Course_number: MATH0321

Credit_hours: 3

Department: MATH

• Section

Section_identifier:10

Course_number: CS0221

Semester: Fall

Year:08

Instructor: Walker

Section_identifier: 12

Course_number: CS0402

Semester: Fall

Year: 09

Instructor: Johnson

Section_identifier: 14

Course_number: CS0404

Semester: Fall

Year: 09

Instructor: Stone

Section_identifier: 16

Course_number: Math0321

Semester:Fall

Year:09

Instructor: Hayes

Section_identifier: 14

Course_number: CS0404

Semester: Spring

Year: 08

Instructor: Stone

Section_identifier:10

Course_number: CS0221

Semester: Spring

Year:08

Instructor: Walker

• Grade Report

Student_number: 17

Section_identifier: 14

Grade: C

Student_number: 17

Section_identifier: 16

Grade: B

Student_number: 8

Section_identifier: 14

Grade: B

Student_number: 103

Section_identifier: 14

Grade: B

Student_number: 103

Section_identifier: 16

Grade: A

Student_number: 103

Section_identifier: 92

Grade: C

Student_number: 228

Section_identifier: 14

Grade: A

Student_number: 228

Section_identifier: 92

Grade: B

• Return the following lists
  • all student ids, student names, majors
  • student ids, section identifier, and grade for any student that enrolled in section identifier 92 or 14 or 16
  • all student ids, student names, majors, course name, course number, term, year, grade
  • Course_name, course_number, and credit_hours for all courses taught in 08 or 09
• Provide a list that answers each question:
  • Did any student earn an A in Discrete Structures and also in Java Programming?
  • Did any student earn all As?
  • Was a class offered in every semester?
  • When did instructor Walker teach a course, if any.
• These questions are a bit more advanced than #4.
  • How many times was each class offered?
  • How many courses did each student enroll?
  • Which students name ends in e?
  • Which students name ends in n?
  • Did anyone earn all As in their CS courses?