CODING QUESTIONS:
• Maximum Permutation After Removing Vowels
• Count Special Subarrays of Size 3 (a + c = b)
• Maximum Number of People Using Lift Without Exceeding Capacity
• Longest Substring Containing Only Consonants
• Check if Sum of Even-Indexed Elements > Sum of Odd-Indexed Elements
• Count Strings With More Vowels Than Consonants
• Maximum Difference Between Digit Sums in an Array
• Maximum ASCII Difference Between Adjacent Characters
SQL QUESTIONS:
• Delete duplicate rows but keep one instance (using ROW_NUMBER).
• Fetch employee details whose name starts with vowel.
• Display employees whose salary is between 40,000 and 60,000.
• Retrieve employees who do not belong to the HR department.
• Write a query to get the highest salary in each department.
• List employees along with their manager names (self join).
• Find the department with the maximum salary expense.
• Fetch the 3 most recently joined employees.
SQL QUESTIONS (Set 2):
• Write a query to calculate total, average, and count of salaries.
• Merge two tables based on a matching column and remove mismatches.
• Write a query to fetch employees having NULL in manager_id.
• Write SQL to pivot rows into columns.
• Find customers who placed more than 5 orders.
• Retrieve all product names and total sales (sum quantity).
• List employees who earn more than their manager.
• Write a query to fetch students whose marks improved year-over-year.
• Write a query to display employees with the longest names.
SQL QUESTIONS (Set 3):
• Retrieve the top 3 highest salaries from the Employee table.
• Write a query to find employees who have never made a sale (NOT IN or LEFT JOIN).
• Find the second highest salary using SQL (multiple methods).
• Display departments with more than 5 employees.
• Write a query to count employees grouped by department.
• Fetch records where the salary is higher than the company average salary.
• List employees who joined in the last 30 days.
• Write a query to fetch duplicate records from a table.
CODING QUESTIONS (Set 2):
• Validate Parentheses String With One Allowed Mismatch
• Maximum Frequency Difference in a String
• Count Numbers With Exactly K Set Bits
• First Non-Repeating Character in Entire String Array
• Count numbers whose reversed value is also present in the array
• Find the longest prefix where sum of digits is strictly increasing
• Count strings where consonant count is a prime number
• Check if rearranging characters of a string can form a palindrome
CODING QUESTIONS (Set 3):
• Count Strings That Become Palindrome After Removing One Character
• Sort Strings by Number of Distinct Characters
• Longest Balanced Substring of 0s and 1s
• Check if Any Two Numbers Sum Up to K
• Remove Duplicate Characters to Form Lexicographically Smallest String
• Count Pairs Whose XOR is Even
• Maximum Product of Two Distinct Elements in Array
• Count Strings With Same First and Last Character