Write SQL queries for the following:

DML Commands

1. List the student name, GPA from student table.

2. List the name of student who are scoring GPA in between 2.9 and 3.9

3. List the sID, cName, decision of applications that are accepted.

4. List the sID, cName of applications which are filled at Stanford.

5. List the colleges not in California.

greater than 17000 and scored GPA less than 3.8.

6. List names of all student who came from high school having size

7. List the student names those are starting with H and with five characters.

8. Modify the GPA of all students by giving 10% raise in their GPA.

9. List the details of the students in order of the ascending of GPA and

descending of DoB.

10. List the sIDs of student who apply in either Stanford, Cornell or MIT college.

Joins

1. List the sID, major of the students whose applications got accepted.

2. List sID, sNames of students who applied for major CS.

3. List the cName, state of the colleges which are offering major history.

4. List sName of students whose GPA is above the average GPA of their major.

5. List sName, cName whose application is accepted for major CS.

6. List sID, sName of students who applied for more than 3 majors.

7. List sName of students who applied for more than 2 majors and accepted for atleats one major.

8. Display the average GPA, major where more than 3 students are applied for a major.

9. List sNames of students who applied for colleges in 'CA' state.

10. List sNames of students who applied for college which enrollment is more than 25000.

Nested queries

1. IDs and names of students who have applied to major in CS at some college.

2. Find ID and name of student having same high school size as Jay.

3. Find the name of student with their GPA and Sid whose GPA not equal to GPA of Irene?

4. 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)

5. Find details of Students who applied to major CS but not applied to major EE? (sID

987, 876, 543 should only be include in result)

6. 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)

7. Find the college with highest enrollment.

8. Find name of student having lowest GPA.

9. Find the most popular major.

10. Find IDs of student and major who applied in any of major Irene had applied to?

Ctanallawt