IndiaMART interview question

Joins, Second highest value in sql. Query. Frequency of every charcter in a string. Project compulsary.