SQL. Problems and SolutionsNew sql featuresNew sql featuresMERGE statementRanking functionsWindow functionsCROSS APPLY / OUTER APPLYCONCAT functionPIVOT and UNPIVOT OperatorsCommon table expressions (CTE)EOMONTH functionSTRING_AGG functionSTRING_SPLIT functionCHOOSE functionTRANSLATE function