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