SQL. Problems and SolutionsNew sql featuresNew sql featuresMERGE statementAbout ranking functionsAbout window functionsCROSS APPLY / OUTER APPLY operatorsCONCAT functionPIVOT and UNPIVOT OperatorsCommon table expressions (CTE)EOMONTH functionSTRING_AGG functionSTRING_SPLIT functionCHOOSE functionTRANSLATE function