Give the SQL command and the resulting table that was generated. a) List the nam

Question

Give the SQL command and the resulting table that was generated. a) List the names of all students applying to a major related to biology. b) Find the number of students applying to Cornell? c) Determine the number of applications (not students/applicants) to each college. d) Give the name of the college with the highest average minimum GPA. e) List the names and ids of the students that applied to all schools. f) List the names and ids of the students that applied to OSU but did not apply to U of O. g) For students with GPA's higher than the minimum requirements for the major they applied for, give the student's name, GPA, college name and major.

Explanation / Answer

A) select sID from Student where sID IN
(select sID from Apply where major LIKE 'biology%')

B) select count (DISTINCT sID) from apply where cName like 'Cornell'

C) SELECT COUNT(Sid), Cname
FROM Apply
GROUP BY Cname

D) select major,max (avg_salary) from (select major, avg(minGPA) AS avg_salary from MinimuGPA group by major);

E) select sName,sID from Apply
where count(distinct cName) >=4

F) select sID,cName from Apply where major like 'OSu' and major not like 'U of O'

G) select sName,GPA,cName,major from Student,Apply where decision like 'Y%'
and Apply.sID=Student.sID

Related Questions

Navigate

• Browse (All)
• Browse G
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.