What are the benefits provided by a CTE $($Common Table Expression$)?$

Each correct answer represents a complete solution. Choose all that apply.

A

Used to reference the resulting table multiple times in the same statement

B

Users do not have to store the definition in metadata A

C

Takes normalized data and display it like a spreadsheet D

D

Used to create a recursive query $C$