SQL Nested Functions Challenge Set – Easy, Medium & Hard Unisoft
Comprehensive SQL Challenge Set (Easy → Medium → Hard)
Each level progressively increases in difficulty, requiring multiple nested functions.
🟢 Easy Level
Retrieve employees whose names have exactly 5 characters, converted to uppercase, and sorted by salary.
Hint: Use LENGTH(), UPPER(), and ORDER BY SAL.
Display employees whose names contain the letter 'A', replacing all occurrences of 'A' with '@', trimmed to remove spaces.
Hint: Use INSTR(), REPLACE(), TRIM(), and ORDER BY JOB.
🟡 Medium Level
Extract the last three characters of each employee’s name, concatenate them with the job title, and convert the result to title case (InitCap) while removing leading spaces.
Hint: Use SUBSTR(), LTRIM(), CONCAT(), and INITCAP().
Replace all vowels in employee names with '#', then pad the result with '@' to make every name exactly 10 characters long, sorted by department number.
Hint: Use TRANSLATE(), LPAD(), LENGTH(), and ORDER BY DEPTNO.
🔴 Hard Level
Extract the middle three characters of an employee’s name (if the length is odd) or middle four characters (if the length is even), replace all vowels in this substring with '#', and order by salary in descending order.
Hint: Use SUBSTR(), TRANSLATE(), LENGTH(), RPAD(), and ORDER BY SAL DESC.
Retrieve employees whose job title contains more than 6 characters, trim spaces, reverse the name, and concatenate it with the reversed job title.
Hint: Use RTRIM(), SUBSTR(), INSTR(), CONCAT(), and ORDER BY JOB.