print Question 1 select b.bname, b.postal-code from building b where address LIK

Question

print Question 1 select b.bname, b.postal-code from building b where address LIKE "%North Campus%"; .print Question 2 select distinct title, instructor from course c, building b, course-schedule cs where c. course-id = cs.co.id and cs.bname = b.bname and b.bname like "%ETLC " and cs . semester = 'Fall 2017'; print Question 3 select s.name from student s, course c, take t where s. student id = t.st id and c.course id = t.co id and c. type = "Grad" except gelect s.name rom student s, course c,take t whee s.student _id t.st_id and c.course_id t.co_id and c.type Undergrad print Question 1 gelect c nam Lrom student s, take t, course schedule where s.student_id t.st_id and t.co_id cs.co_id and t.semester = 'Fa ll 2017' group by bname having count (s.stndent id) = (se l ct max (num) trom (se lect count (S·Student id) as nn Lrom sudent s, Lake L, course schedule c where s.student id L.st id and L.co id es. id and t.semester Fal1 01' grop by bnamc)) print. Qustion b = 'F.) 11 201,/ '

Explanation / Answer

Query 5

select s.name from student s,course_schedule cs, take t where s.student_id = t.st_id and t.semester = 'Fall 2017' and t.co_id = ( select cs.co_id from course_schedule cs where cs.co_day = 'Monday' and cs.co_day = 'Tuesday' and cs.co_day = 'Wednesday' and cs.co_day = 'Thursday' and cs.co_day = 'Friday');

Query 4

select cs.bname from student s, take t, course_schedule cs where s.student_id = t.st_id and t.co_id = cs.co_id and t.semester = 'Fall 2017' group by bname having count(s.student_id) = (select max(num) from (select count (s.student_id) as num from student s, take t, course_schedule cs where s.student_id = t.st_id and t.co_id = cs.co_id and t.semester = 'Fall 2017' group by bname));

Output

ETLC

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

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