Icreon Interview Question

WAP to count occurance of repeated chars in a string using streams SQL query for second highest salary