Java Developer & SQL Interview Coding Questions | asked were at Societe Generale & Hardwin Software.

Interview Coding Questions SQL Query: Find the unique departments where the average salary is greater than 70,000. Description: This query filters departments with an average salary above a specific threshold using aggregate functions like AVG and GROUP BY. SQL Query: Rank employees based on their salary using the RANK() window function and find the highest salary of an employee. Description: This query combines the use of the RANK() function to assign rankings to employees based on their salaries and identifies the highest-paid employee. Core Java Problem 1: Find the maximum occurring element in a given list of integers. Description: Identify the most frequent element in a list using Core Java's data structures like Map and loops for counting occurrences. Problem 2: Find the maximum occurring character in a sentence using Java 8 (Streams API). Description: Leverage Java 8's Streams API for efficient character frequency calculation and find the character with the maximum count. Connect with Us Hardwin Software Solutions https://www.linkedin.com/company/hardwinsoftware/ Societe Generale https://www.linkedin.com/company/societe-generale/ Manish Kumar LinkedIn Profile https://www.linkedin.com/in/manish-kumar-4ba7771a8/ LinkedIn Page URL https://www.linkedin.com/company/104581726/admin/dashboard/