Hello. for this question we are working on subqueries vs joins. I have already created a subquery q74 and a CREATE VIEW v153.

I am having a difficult time figureing out the last part. How do I do the following: When you have the outer query and the subquery results, recall the original query that you saved (q74) and add the subquery. Check your result with the department lists you just generated. Redo the last part of the experiment with your view. You should get the same result.? Remember, one is a querie the other is a view. Please help. Thank you.

Find the names of departments that offer courses at the junior or senior levels (either one) but not at the freshman level. (The course level is the first digit after the prefix. Therefore, AAAA3yyy is a junior course, and so on.) Hint: Begin by creating the outer querythe names of departments that offer courses at the junior or senior levels. Save this query as q74. Then, construct the subquerya list of departments that offer courses at the freshman level. Save the153 subquery as a view. Examine both lists of departments.

When you have the outer query and the subquery results, recall the original query that you saved (q74) and add the subquery. Check your result with the department lists you just generated. Redo the last part of the experiment with your view. You should get the same result.

SQL> CREATE VIEW v153 AS 2 SELECT DISTINCT offering dept FROM CouEse number 3 FROM Course 4 WHERE course number 5 LIKE' _' 1 View created