Which of the following was taught as a requirement about using PIVOT$()$ queries

Group of answer choices

You can use dates such as months, but not textual dimensions in the columns

you must use all the values of the dimension that specifies the columns

place the higher cardinality dimension on the columns

you must specify only three columns of data in the base SELECT query