Scribd
Upload
66 views2 pages

SQL Assignment - Wishlist

The document contains 12 SQL query questions regarding student application data. The questions ask to produce combined tables of students and applications, retrieve student and application details by criteria like GPA, college, and major. They also ask to find student counts by GPA for each college, and identify students with the same GPA or a single application.

Uploaded by

ajeetgusain77
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
66 views2 pages

SQL Assignment - Wishlist

The document contains 12 SQL query questions regarding student application data. The questions ask to produce combined tables of students and applications, retrieve student and application details by criteria like GPA, college, and major. They also ask to find student counts by GPA for each college, and identify students with the same GPA or a single application.

Uploaded by

ajeetgusain77
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

L2 Technical Support Engineer Assignment || Wishlist

Write SQL Queries for the following:

Q1. Produce a combined table in which each student is combined with every other
application.
Ans.

Q2. Give Student ID, name, GPA and name of college and major each student applied
to.
Ans.
Q3. Find details of applications who applied to California State.
Ans.

Q4. IDs, name, GPA of students and name of college with GPA > 3.7 applying to
Stanford
Ans.

Q5. Find detail of Student who apply to CS major and their application are rejected
Ans.

Q6. Find detail of student and application who applied to colleges at New York
Ans.

Q7. Find detail of student who have not applied to any of college
Ans.

Q8. Find college where no student have applied


Ans.

Q9. Find sID who have only one application


Ans.

Q10. Find the name and GPA of applicants who apply to any college whose enrollment
is not more than 25000.
Ans.

Q11. Find a pair of students (sID) having the same GPA. (each pair should occur just
once in result
Ans.

Q12. For every unique cName, count the number of students who scored <3 GPA and
who scored >= 3 GPA in 2 separate columns
Ans.

You might also like