In SQL, specifically running on Oracle, write the following query: \" Find the n

Question

In SQL, specifically running on Oracle, write the following query: " Find the names and majors of students who are taking one of the World History courses."

Note: Creation of temporary tables to solve the problem is not permitted. It must be completed in a single query statment. You may not create any tables nor can you alter the structure of the database. The only thing you can do is to create a single SQL query statement that uses the existing structure defined in the schema.

Please provide output.

Database Schema

Pertinent Table Information

I am only posting the Major, Student, and Enroll table since the other tables are not relevant for this specific problem.

MAJOR TABLE

STUDENT TABLE

ENROLL TABLE

dept(dname, numphds) course(cno, cname, dname) prof (pname, dname) section(cno, dname, sectno, pname) student(sid, sname, sex, age, gpa) major(sid, dname) enroll(sid, cno, dname, sectno, grade)

Explanation / Answer

select DISTINCT Student.SNAME, ENROLL.DNAME
from ((STUDENT INNER JOIN ENROLL on Student.SID = ENROLL.SID) INNER JOIN Student.SID = MAJOR.SID)
where MAJOR.DNAME = 'History';

The above query joins the three(Student, Mojor, Enroll) tables with the student ID as foreign key in Major and Enroll tables, and fetches the Student name and Department name.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.