Suppose we have the below table and data

--Declare the table variable
DECLARE @T TABLE(Names VARCHAR(100))

-- Insert Some Value
INSERT INTO @T (Names)
VALUES ('Niladri;Arina;Rajlaxmi'),('Niladri;Arina'),('Niladri')

-- Retrieve data
SELECT *
FROM @T

After execution the result is

Names
---------
Niladri;Arina;Rajlaxmi
Niladri;Arina
Niladri

What will be the count of "Niladri","Arina","Rajlaxmi" after executing the below query in SQL Server 2016?

SELECT X.value AS Names, COUNT(X.value) AS NamesCount
FROM @T
CROSS APPLY STRING_SPLIT(Names,';') X
GROUP BY X.value