Submitted by.
Ashish Kumar
MCA(C)
[Link].12584200049
Submitted to …………….
Query.1. . IDs and names of students who have applied to major in CS at some college.
Query.2. IDs and names of students who have applied to major in CS at some college.
Query.3. Find ID and name of student having same high school size as Jay but result
should not include Jay.
Query.4. Find the name of student with their GPA and Sid whose GPA not equal to GPA
of Irene?
Query.5 Find college where any student having their name started from J have applied?
Query.6. Find all different major where Irene has applied?
Query. 7.. Find IDs of student and major who applied in any of major Irene had applied
to?
Query.8. Find IDs of student and major who applied in any of major Irene had applied
to? But this time exclude Irene Sid from the list.
Query.9. Give the number of colleges Jay applied to? (Remember count each college
once no matter if he applied to same college twice with different major)
Query.10. Find Sid of student who applied to more or same number of college where
Jahas applied?
Query.11. Find details of Students who applied to major CS but not applied to major EE?
(sID987, 876, 543 should only be include in result)
Query.12. All colleges such that some other college is in same state. (Cornell should not
be part of result as no other college in New York Hint: use exists)
Query.13. Find the college with highest enrolment.
Query.14. Find name of student having lowest GPA.
Query.15. Find the most popular major
Query.16. Find Sid, same, size Sof all students NOT from smallest HS.
Query.17. Find the name of student who applies to all the colleges where sID 987 has
applied? (Hint: see Query Find IDs of student applied to all colleges)
Query.18. Find college where all the student have applied.
Query.19. Find Sid of student who have not applied to Stanford.
Query.20. Find Sid of Student that applied to both Stanford and Berkeley
Query.21. Give list of all names including all names of colleges and students.
Query.22. Create a table ApplicationInfohaving columns Sid: int,sName: varchar2(10)
and number_of_applications: number (2) they filed? Populate this table with
appropriate data using insert command.
Query.23. Create table Application Data and load with ID, name and college where they
applied with state of college (remember to include details of ALL students that have
applied or not applied) on runtime using single query.
Query.24. Stanford decides not to take any student who have also applied to its rival
Berkeley turn their application decision to N.
Query.25. Delete applications that are filed to city ‘New York’.