%252525253Cp%252525253E%252525253Cspan%2525252520class%252525253D%2525252522c1%2

Question

%252525253Cp%252525253E%252525253Cspan%2525252520class%252525253D%2525252522c1%2525252522%252525253ESchema%252525253A%252525253C%252525252Fspan%252525253E%252525253C%252525252Fp%252525253E%252525250A%252525253Cp%2525252520class%252525253D%2525252522MsoPlainText%2525252520c4%2525252522%252525253E%252525253Cspan%2525252520class%252525253D%2525252522c2%2525252522%252525253EYou%2525252520will%2525252520have%2525252520to%2525252520write%252525250ASQL%2525252520queries%2525252520against%2525252520the%2525252520following%2525252520%252525253C%252525252Fspan%252525253E%252525253Cspan%2525252520class%252525253D%252525250A%2525252522c3%2525252522%252525253Edatabase%2525252520schema%2525252520(keys%2525252520are%2525252520in%2525252520bold)%252525253A%252525253C%252525252Fspan%252525253E%252525253C%252525252Fp%252525253E%252525250A%252525253Cp%2525252520class%252525253D%2525252522MsoPlainText%2525252520c4%2525252522%252525253E%252525253Cspan%2525252520class%252525253D%2525252522c3%2525252522%252525253E%2525252526nbsp%252525253B%252525253C%252525252Fspan%252525253E%252525253C%252525252Fp%252525253E%252525250A%252525253Cp%2525252520class%252525253D%2525252522MsoPlainText%2525252520c6%2525252522%252525253E%252525253Cspan%2525252520class%252525253D%2525252522c5%2525252522%252525253E%25252525C2%25252525B7%252525253C%252525252Fspan%252525253E%252525253Cspan%2525252520class%252525253D%252525250A%2525252522c2%2525252522%252525253E%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%252525253C%252525252Fspan%252525253E%252525253Cspan%2525252520class%252525253D%2525252522c5%2525252522%252525253Estudent(%252525253Cb%252525253E%252525253Cu%252525253Esid%252525253C%252525252Fu%252525253E%252525253C%252525252Fb%252525253E%252525252C%252525250Asname%252525252C%2525252520sex%252525252C%2525252520age%252525252C%2525252520year%252525252C%2525252520gpa)%252525253C%252525252Fspan%252525253E%252525253C%252525252Fp%252525253E%252525250A%252525253Cp%2525252520class%252525253D%2525252522MsoPlainText%2525252520c6%2525252522%252525253E%252525253Cspan%2525252520class%252525253D%2525252522c5%2525252522%252525253E%25252525C2%25252525B7%252525253C%252525252Fspan%252525253E%252525253Cspan%2525252520class%252525253D%252525250A%2525252522c2%2525252522%252525253E%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%252525253C%252525252Fspan%252525253E%252525253Cspan%2525252520class%252525253D%2525252522c5%2525252522%252525253Edept(%252525253Cb%252525253E%252525253Cu%252525253Edname%252525253C%252525252Fu%252525253E%252525253C%252525252Fb%252525253E%252525252C%252525250Anumphds)%252525253C%252525252Fspan%252525253E%252525253C%252525252Fp%252525253E%252525250A%252525253Cp%2525252520class%252525253D%2525252522MsoPlainText%2525252520c6%2525252522%252525253E%252525253Cspan%2525252520class%252525253D%2525252522c5%2525252522%252525253E%25252525C2%25252525B7%252525253C%252525252Fspan%252525253E%252525253Cspan%2525252520class%252525253D%252525250A%2525252522c2%2525252522%252525253E%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%252525253C%252525252Fspan%252525253E%252525253Cspan%2525252520class%252525253D%2525252522c5%2525252522%252525253Eprof(%252525253Cb%252525253E%252525253Cu%252525253Epname%252525253C%252525252Fu%252525253E%252525253C%252525252Fb%252525253E%252525252C%252525250Adname)%252525253C%252525252Fspan%252525253E%252525253C%252525252Fp%252525253E%252525250A%252525253Cp%2525252520class%252525253D%2525252522MsoPlainText%2525252520c6%2525252522%252525253E%252525253Cspan%2525252520class%252525253D%2525252522c5%2525252522%252525253E%25252525C2%25252525B7%252525253C%252525252Fspan%252525253E%252525253Cspan%2525252520class%252525253D%252525250A%2525252522c2%2525252522%252525253E%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%252525253C%252525252Fspan%252525253E%252525253Cspan%2525252520class%252525253D%2525252522c5%2525252522%252525253Ecourse(%252525253Cb%252525253E%252525253Cu%252525253Ecno%252525253C%252525252Fu%252525253E%252525253C%252525252Fb%252525253E%252525252C%252525250Acname%252525252C%2525252526nbsp%252525253B%252525253Cb%252525253E%252525253Cu%252525253Edname%252525253C%252525252Fu%252525253E%252525253C%252525252Fb%252525253E)%252525253C%252525252Fspan%252525253E%252525253C%252525252Fp%252525253E%252525250A%252525253Cp%2525252520class%252525253D%2525252522MsoPlainText%2525252520c6%2525252522%252525253E%252525253Cspan%2525252520class%252525253D%2525252522c5%2525252522%252525253E%25252525C2%25252525B7%252525253C%252525252Fspan%252525253E%252525253Cspan%2525252520class%252525253D%252525250A%2525252522c2%2525252522%252525253E%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%252525253C%252525252Fspan%252525253E%252525253Cspan%2525252520class%252525253D%2525252522c5%2525252522%252525253Emajor(%252525253Cb%252525253E%252525253Cu%252525253Edname%252525253C%252525252Fu%252525253E%252525253C%252525252Fb%252525253E%252525252C%2525252526nbsp%252525253B%252525253Cb%252525253E%252525253Cu%252525253Esid%252525253C%252525252Fu%252525253E%252525253C%252525252Fb%252525253E)%252525253C%252525252Fspan%252525253E%252525253C%252525252Fp%252525253E%252525250A%252525253Cp%2525252520class%252525253D%2525252522MsoPlainText%2525252520c6%2525252522%252525253E%252525253Cspan%2525252520class%252525253D%2525252522c5%2525252522%252525253E%25252525C2%25252525B7%252525253C%252525252Fspan%252525253E%252525253Cspan%2525252520class%252525253D%252525250A%2525252522c2%2525252522%252525253E%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%252525253C%252525252Fspan%252525253E%252525253Cspan%2525252520class%252525253D%2525252522c5%2525252522%252525253Esection(%252525253Cb%252525253E%252525253Cu%252525253Edname%252525253C%252525252Fu%252525253E%252525253C%252525252Fb%252525253E%252525252C%2525252526nbsp%252525253B%252525253Cb%252525253E%252525253Cu%252525253Ecno%252525253C%252525252Fu%252525253E%252525253C%252525252Fb%252525253E%252525252C%2525252526nbsp%252525253B%252525253Cb%252525253E%252525253Cu%252525253Esectno%252525253C%252525252Fu%252525253E%252525253C%252525252Fb%252525253E%252525252C%252525250Apname)%252525253C%252525252Fspan%252525253E%252525253C%252525252Fp%252525253E%252525250A%252525253Cp%2525252520class%252525253D%2525252522MsoPlainText%2525252520c6%2525252522%252525253E%252525253Cspan%2525252520class%252525253D%2525252522c5%2525252522%252525253E%25252525C2%25252525B7%252525253C%252525252Fspan%252525253E%252525253Cspan%2525252520class%252525253D%252525250A%2525252522c2%2525252522%252525253E%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%2525252526nbsp%252525253B%252525253C%252525252Fspan%252525253E%252525253Cspan%2525252520class%252525253D%2525252522c5%2525252522%252525253Eenroll(%252525253Cb%252525253E%252525253Cu%252525253Esid%252525253C%252525252Fu%252525253E%252525253C%252525252Fb%252525253E%252525252C%252525250Agrade%252525252C%2525252526nbsp%252525253B%252525253Cb%252525253E%252525253Cu%252525253Edname%252525253C%252525252Fu%252525253E%252525253C%252525252Fb%252525253E%252525252C%2525252526nbsp%252525253B%252525253Cb%252525253E%252525253Cu%252525253Ecno%252525253C%252525252Fu%252525253E%252525253C%252525252Fb%252525253E%252525252C%2525252526nbsp%252525253B%252525253Cb%252525253E%252525253Cu%252525253Esectno%252525253C%252525252Fu%252525253E%252525253C%252525252Fb%252525253E)%252525253C%252525252Fspan%252525253E%252525253C%252525252Fp%252525253E%252525250A%252525253Cp%252525253E%252525253Cspan%2525252520class%252525253D%2525252522c1%2525252522%252525253E%252525253Cbr%2525252520%252525252F%252525253E%252525253C%252525252Fspan%252525253E%252525253C%252525252Fp%252525253E%252525250A%252525253Cp%252525253E%252525253Cspan%2525252520class%252525253D%2525252522c1%2525252522%252525253EQuestion%252525253A%2525252520Some%2525252520courses%2525252520are%2525252520popular%2525252520among%252525250Astudents%2525252520just%2525252520because%2525252520students%2525252520enrolled%2525252520in%2525252520those%2525252520courses%2525252520usually%252525250Aget%2525252520good%2525252520grades.%2525252520Print%2525252520the%2525252520department%2525252520name%252525252C%2525252520course%2525252520number%252525252C%2525252520and%252525250Acourse%2525252520enrollment%2525252520of%2525252520each%2525252520course%2525252520C%2525252520such%2525252520that%2525252520the%2525252520following%2525252520two%252525250Aconditions%2525252520hold%252525253A%2525252520(1)%2525252520course%2525252520C's%2525252520enrollment%2525252520is%25252525203%2525252525%2525252520larger%2525252520than%2525252520the%252525250Aaverage%2525252520enrollment%2525252520of%2525252520courses%2525252520offered%2525252520by%2525252520C's%2525252520department%252525252C%2525252520and%2525252520(2)%252525250Acourse%2525252520C's%2525252520average%2525252520grade%2525252520is%25252525203%2525252525%2525252520larger%2525252520than%2525252520the%2525252520average%2525252520grade%252525250Aobtained%2525252520by%2525252520students%2525252520in%2525252520courses%2525252520offered%2525252520by%2525252520C's%2525252520department.%2525252520Assume%252525250Athat%2525252520the%2525252520enrollment%2525252520of%2525252520a%2525252520course%2525252520is%2525252520the%2525252520sum%2525252520of%2525252520the%2525252520enrollment%2525252520of%2525252520all%252525250Aits%2525252520sections.%2525252520You%2525252520can%2525252520completely%2525252520ignore%2525252520any%2525252520course%2525252520that%2525252520has%2525252520no%252525250Astudents%2525252520enrolled%2525252520in%2525252520it.%252525253C%252525252Fspan%252525253E%252525253C%252525252Fp%252525253E%252525250A

Explanation / Answer

Answer:

select d.dname, d.cname, d.enroll form
(select avg(enrollment) as avg from (select count(sid) as enrollment from enroll group by cno) t)a,
(select count(sid) as enrollment, cno from enroll group by cno)b,
(select avg(gpa) as avggpa, cno from sutudent, enroll where student.sid = enroll.sid group by enroll.cno)c,
(select course.dname, course.cname, count(enroll.sid) as enroll, cno form course, enroll group by cno)d,
(select avg(avggpa) as totalavg from (select avg(gpa) as avggpa, cno from sutudent, enroll where student.sid = enroll.sid group by enroll.cno)c)e
where d.enroll > 1.03*a.avg and c.avggpa > 1.03*e.totalavg and b.cno = c.cno and d.cno = c.cno);

I hope this works.

If there is any error do inform.

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

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