Which statements are true of a projection? (Select two.)
A.
They can contain a comparison predicate.
B.
They can contain a join condition.
C.
They can only be created prior to loading data.
D.
They can be created at any time, either before or after data is loaded into a table.
E.
They can contain aggregate functions.
Explanation: