Question
In SQL, specifically running on Oracle, write the following query: How many students have more than one major? Note: This must be done with a
In SQL, specifically running on Oracle, write the following query: "How many students have more than one major?"
Note: This must be done with a nested query. 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. DO NOT insert any tables or modify any tables. The solution must be one statement. The only thing you can do is to create a single SQL query statement that uses the existing structure defined in the schema.
Based on the information provided, the correct output for the query should be 2.
Database Schema
Pertinent Table Information
COURSE TABLE
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)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started