Answered step by step
Verified Expert Solution
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
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 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
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started