EN$-$US

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\mathrm{.}9$ and $3\mathrm{.}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\mathrm{.}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 $\text{'}$CA$\text{'}$ 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$?$Answer the all the questions including joins also