phpMyAdmin help :

I have done so far for other parts:

a)students table

INSERT INTO students (id, Name, Location,EmailAddress) VALUES ('1', 'Student1', 'Miami','Student1@google.com');

INSERT INTO students (id, Name, Location,EmailAddress) VALUES ('2', 'Student2', 'Tampa','Student2@google.com');

INSERT INTO students (id, Name, Location,EmailAddress) VALUES ('1', 'Student3', 'Melbourne','Student3@google.com');

INSERT INTO students (id, Name, Location,EmailAddress) VALUES ('1', 'Student4', 'Orlando','Student4@google.com');

b)courses table

INSERT INTO courses(id, Name, Instructor) VALUES ('1', 'Multifarious System','Instructor1');

INSERT INTO courses(id, Name, Instructor) VALUES ('2', 'Micro Computers','Instructor2');

INSERT INTO courses(id, Name, Instructor) VALUES ('3', 'Speech Recognition','Instructor3');

INSERT INTO courses(id, Name, Instructor) VALUES ('4', 'Speech Processing','Instructor4');

c)scores table

INSERT INTO courses(StudentID, CourseID, Scores) VALUES ('1', '2','75');

INSERT INTO courses(StudentID, CourseID, Scores) VALUES ('2', '2','78');

INSERT INTO courses(StudentID, CourseID, Scores) VALUES ('3', '2','92');

INSERT INTO courses(StudentID, CourseID, Scores) VALUES ('2', '1','75');

INSERT INTO courses(StudentID, CourseID, Scores) VALUES ('3', '1','20');

INSERT INTO courses(StudentID, CourseID, Scores) VALUES ('3', '3','10');

INSERT INTO courses(StudentID, CourseID, Scores) VALUES ('2', '3','98');

INSERT INTO courses(StudentID, CourseID, Scores) VALUES ('1', '3','50');

INSERT INTO courses(StudentID, CourseID, Scores) VALUES ('2', '4','10');

INSERT INTO courses(StudentID, CourseID, Scores) VALUES ('3', '4','16');

Question help : Using only one SQL query

Thank you.

Questions Answers the following questions using only one SQL query per question: 1. 95 Add the following values to the scores table. StudentID = 5, Course! D = 4, Score What do you observe? Why? List the student id and name of students enrolled in Multifarious System List the student id, name and course name of students enrolled in either Multifarious System or Micro Computer. Order by student id in ascending order (Hint: use IN, inner join) List the student id, name and course name of students enrolled in courses starting with the word 'Speech'. List all students who got scores between 70 and 100. (Hint: use BETWEEN). Don't list the same student twice Find the name and location of students who failed at least one course. Assume that passing scores are 40 or higher. Do not list the same student twice if the student failed multiple courses. Find the location, id and name of student(s) who failed exactly 3 courses. Find the name of the student(s) who got the highest score in some subject. The Query output should show student name, course ID, score, and course name in which he or she got the highest score. (Hint: use GROUP BY, JOIN) 2. 3. 4. 5. 6. 7. 8. Extra credit (5 Points) List the id and name of students not enrolled in Speech Processing 9