NULLIFUNPIVOT operatorPIVOT and UNPIVOT OperatorsThe sorting and NULL valuesGetting summarizing valuesCASE statementSELECT statement