SQL Puzzle: SQL Advance Query – Use PARSENAME() and Sort the IP-Addresses

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

Check the below input data and expected output to sort the IP-Addresses in the correct order.
(Use PARSENAME() for splitting the IP-Addresses into four parts and then get the correct sorted result)
Input Data:

Expected Output:

Create a table with data:

Solution: Using PARSENAME()

Please try the different solution for this puzzle and share it via comment...