Crowdly

Add to Chrome

Given the following SQL query: studinfo( studid , name, sex) enroll(studId, ...

✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.

Given the following SQL query:

studinfo(studid, name, sex)

enroll(studId, courseId)

SELECT DISTINCT e.courseId

FROM enroll e

WHERE e.courseId NOT IN (

SELECT DISTINCT e1.courseId

FROM enroll e1

JOIN studInfo s ON e1.studId = s.studId

WHERE s.sex = 'female'

);

Which of the following Relational Algebra expressions correctly represents this query?

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!

Add to Chrome