Question $4.(25$ points$)-$ CTE$/$Subquery

Using the query you developed in Question $3,$ write a subquery or a CTE to return the same

results as Question $3.$ Your result set should match the result set shown in Question $3.$

$($the first $10$ rows are shown$)$

$(47$ rows are returned; the last $10$ rows are shown$)$

Extra Credit: Explain the difference between a CTE and a subquery. Why did you

choose one vs the other for your solution to Question $4?(+2$ points$)$