Describe how the query contained in the common table expression (CTE) works. Are correlated or uncorrelated subqueries leveraged? Are the query results filtered? If yes, how are the results filtered? Are table joins used in the query? If yes, what tables are linked together? Are aggregate functions leveraged in the query? If yes, describe what results are being sought along with the applicable grouping parameters.