Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

QUESTION about sqlite. how to do query 4 and query 5? I have already done first 4 but not sure the about 4th one. I

image text in transcribed

image text in transcribedQUESTION about sqlite. how to do query 4 and query 5? I have already done first 4 but not sure the about 4th one. I dont know how to do query 5 . the data can be found in https://drive.google.com/drive/folders/1Quu_pVIzPePrDf2kct9O3slOqA4hVPwM?usp=sharing

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 (SStudent 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,/

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started