Question: Using Entertainment Agency Example, suppose you would like to remove all musical styles that are NOT played by any entertainers AND are NOT favored by

Using Entertainment Agency Example, suppose you would like to remove all musical styles that are NOT played by any entertainers AND are NOT favored by any customers.

Which of the statements below would best accomplish this task?

Question 4 options:

DELETE FROM Musical_Styles WHERE StyleID NOT IN (SELECT StyleID FROM Entertainer_Styles) OR StyleID NOT IN (SELECT StyleID FROM Musical_Preferences)

DELETE FROM Musical_Styles WHERE StyleID NOT IN (SELECT StyleID FROM Entertainer_Styles) AND StyleID NOT IN (SELECT StyleID FROM Musical_Preferences)

DELETE FROM Musical_Preferences WHERE StyleID NOT IN (SELECT StyleID FROM Musical_Styles) AND StyleID NOT IN (SELECT StyleID FROM Entertainer_Styles)

DELETE FROM Musical_Styles WHERE StyleID IS NULL

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!