What is the CTE equivalent of the SQL with subquery shown ab…