📍InMobi is hiring for Analyst - Microsoft Advertising

Qualification: Bachelors / Masters Degree

Experience: 0-3 years 

Batch: 2025 / 2024 / 2023 / 2022

Salary: up to ₹6.2 - 11 LPA

Job Location: Lucknow

🔗 𝗔𝗽𝗽𝗹𝘆 𝗛𝗲𝗿𝗲: https://techcompreviews.in/inmobi-hiring-analyst-microsoft-ads/

📍Smytten is hiring for Data Analyst Intern

Qualification: Bachelors / Masters Degree

Experience: Fresher 

Batch: 2025 / 2024 / 2023 / 2022

Salary: up to ₹20,000 per month

Job Location: Ahmedabad

🔗 𝗔𝗽𝗽𝗹𝘆 𝗛𝗲𝗿𝗲: https://techcompreviews.in/smytten-hiring-data-analyst-intern/

Tips for solving leetcode codings interview problems

If input array is sorted then
- Binary search
- Two pointers

If asked for all permutations/subsets then
- Backtracking

If given a tree then
- DFS
- BFS

If given a graph then
- DFS
- BFS

If given a linked list then
- Two pointers

If recursion is banned then
- Stack

If must solve in-place then
- Swap corresponding values
- Store one or more different values in the same pointer

If asked for maximum/minimum subarray/subset/options then
- Dynamic programming

If asked for top/least K items then
- Heap

If asked for common strings then
- Map
- Trie

Else
- Map/Set for O(1) time & O(n) space
- Sort input for O(nlogn) time and O(1) space

📍Amazon is hiring for Software Dev Engineer I

Qualification: BE / B.Tech / ME / M.Tech / MCA / MS / M.Sc

Experience: 0-1 years 

Batch: 2025 / 2024 / 2023 / 2022

Salary: up to ₹12-25 LPA

Job Location: Bangalore

🔗 𝗔𝗽𝗽𝗹𝘆 𝗛𝗲𝗿𝗲: https://techcompreviews.in/amazon-recruitment-for-sde-i-freshers/

📍TaskUs is hiring for Business Insights Analyst

Qualification: Bachelors / Masters Degree

Experience: 0-2 years 

Batch: 2025 / 2024 / 2023 / 2022

Salary: up to ₹8.5 LPA

Job Location: Gurugram

🔗 𝗔𝗽𝗽𝗹𝘆 𝗛𝗲𝗿𝗲: https://techcompreviews.in/taskus-hiring-business-insights-analyst/

📍BambooHR is hiring for Specialist - Data Validation

Qualification: Bachelors / Masters Degree

Experience: 2-5 years 

Batch: 2025 / 2024 / 2023 / 2022

Salary: up to ₹7 LPA

Job Location: Gurugram

🔗 𝗔𝗽𝗽𝗹𝘆 𝗛𝗲𝗿𝗲: https://techcompreviews.in/bamboohr-off-campus-hiring-data-validation/

📍HP is hiring for Software Engineer

Qualification: Bachelors / Masters Degree

Experience: 0-1 years 

Batch: 2025 / 2024 / 2023 / 2022

Salary: up to ₹7 LPA

Job Location: Bangalore

🔗 𝗔𝗽𝗽𝗹𝘆 𝗛𝗲𝗿𝗲: https://techcompreviews.in/hp-off-campus-hiring-software-engineer/

📍HealthAsyst is hiring for Market Research

Qualification: Bachelors / Masters Degree

Experience: 0-2 years 

Batch: 2025 / 2024 / 2023 / 2022

Salary: up to ₹5 LPA

Job Location: Bangalore

Job Location: Lucknow

🔗 𝗔𝗽𝗽𝗹𝘆 𝗛𝗲𝗿𝗲: https://techcompreviews.in/healthasyst-off-campus-hiring-market-research/

📍Netomi is hiring for ML Data Analyst

Qualification: Bachelors / Masters Degree

Experience: 2-5 years 

Batch: 2025 / 2024 / 2023 / 2022

Salary: up to ₹11.5 LPA

Job Location: Gurugram

🔗 𝗔𝗽𝗽𝗹𝘆 𝗛𝗲𝗿𝗲: https://techcompreviews.in/netomi-off-campus-hiring-ml-data-analyst/

📍Wipro is hiring for School of IT Infrastructure Management

Qualification: Bachelors / Masters Degree

Experience: Fresher

Batch: 2025 / 2024 / 2023 / 2022

Salary: INR 19,618 per month

Job Location: Bengaluru, INDIA

🔗 𝗔𝗽𝗽𝗹𝘆 𝗛𝗲𝗿𝗲: https://techcompreviews.in/wipro-off-campus-hiring-sim/

📍Zeotap is hiring for Software Engineer - Intern

Qualification: Bachelors / Masters Degree

Experience: Fresher

Batch: 2025 / 2024 / 2023 / 2022

Salary: up to ₹7-8 LPA

Job Location: Bengaluru

🔗 𝗔𝗽𝗽𝗹𝘆 𝗛𝗲𝗿𝗲: https://techcompreviews.in/zeotap-off-campus-hiring-software-engineer-intern/

📍Finastra is hiring for Software Engineer

Qualification: Bachelors / Masters Degree

Experience: Fresher 

Batch: 2025 / 2024 / 2023 / 2022

Salary: up to ₹7 LPA

Job Location: Pune

🔗 𝗔𝗽𝗽𝗹𝘆 𝗛𝗲𝗿𝗲: https://techcompreviews.in/finastra-off-campus-hiring-software-engineer-2/

📍Verizon is hiring for Full stack engineer

Qualification: Bachelors / Masters Degree

Experience: 0-1 years 

Batch: 2025 / 2024 / 2023 / 2022

Salary: up to ₹8-12 LPA

Job Location: Bangalore

🔗 𝗔𝗽𝗽𝗹𝘆 𝗛𝗲𝗿𝗲: https://techcompreviews.in/verizon-off-campus-hiring-full-stack-engineer/

📍SentinelOne is hiring for Solution Architect Intern

Qualification: Bachelors / Masters Degree

Experience: 0-2 years 

Batch: 2025 / 2024 / 2023 / 2022

Salary: up to ₹5 LPA

Job Location: Bangalore

🔗 𝗔𝗽𝗽𝗹𝘆 𝗛𝗲𝗿𝗲: https://techcompreviews.in/sentinelone-hiring-solution-architect-intern/

📍Unisys is hiring for Assoc Tech Svc Desk

Qualification: diploma or GED

Experience: Fresher

Batch: 2025 / 2024 / 2023 / 2022

Salary: up to ₹5 LPA

Job Location: Bangalore

🔗 𝗔𝗽𝗽𝗹𝘆 𝗛𝗲𝗿𝗲: https://techcompreviews.in/unisys-off-campus-hiring-assoc-tech-svc-desk/

📍Tata Technologies is hiring for AI Engineer

Qualification: Bachelors / Masters Degree

Experience: 0-2 years 

Batch: 2025 / 2024 / 2023 / 2022

Salary: up to ₹3-7 LPA

Job Location: PUNE

🔗 𝗔𝗽𝗽𝗹𝘆 𝗛𝗲𝗿𝗲: https://techcompreviews.in/tata-technologies-off-campus-hiring-ai-engineer/

The GROUP BY clause in SQL is used to arrange identical data into groups. This is particularly useful when combined with aggregate functions like COUNT(), SUM(), AVG(), MIN(), and MAX(). The GROUP BY clause groups rows that have the same values in specified columns into summary rows.

▎Basic Syntax

SELECT column1, aggregate_function(column2)
FROM table_name
WHERE condition
GROUP BY column1;

▎Example 1: Counting Rows

Suppose you have a table called employees with the following structure:

| id | department | salary |
|----|------------|--------|
| 1  | HR         | 50000  |
| 2  | IT         | 60000  |
| 3  | HR         | 55000  |
| 4  | IT         | 70000  |
| 5  | Sales      | 65000  |

To find out how many employees are in each department, you can use:

SELECT department, COUNT(*) AS employee_count
FROM employees
GROUP BY department;

Result:

| department | employee_count |
|------------|----------------|
| HR         | 2              |
| IT         | 2              |
| Sales      | 1              |

▎Example 2: Summing Salaries

To calculate the total salary paid to employees in each department, you can use:

SELECT department, SUM(salary) AS total_salary
FROM employees
GROUP BY department;

Result:

| department | total_salary |
|------------|--------------|
| HR         | 105000       |
| IT         | 130000       |
| Sales      | 65000        |

▎Example 3: Average Salary

To find the average salary of employees in each department:

SELECT department, AVG(salary) AS average_salary
FROM employees
GROUP BY department;

Result:

| department | average_salary |
|------------|----------------|
| HR         | 52500          |
| IT         | 65000          |
| Sales      | 65000          |

▎Example 4: Grouping by Multiple Columns

You can also group by multiple columns. For instance, if you had another column for job_title:

| id | department | job_title | salary |
|----|------------|-----------|--------|
| 1  | HR         | Manager   | 50000  |
| 2  | IT         | Developer | 60000  |
| 3  | HR         | Assistant | 55000  |
| 4  | IT         | Manager   | 70000  |
| 5  | Sales      | Executive | 65000  |

To count employees by both department and job_title:

SELECT department, job_title, COUNT(*) AS employee_count
FROM employees
GROUP BY department, job_title;

Result:

| department | job_title | employee_count |
|------------|-----------|----------------|
| HR         | Manager   | 1              |
| HR         | Assistant | 1              |
| IT         | Developer | 1              |
| IT         | Manager   | 1              |
| Sales      | Executive | 1              |

▎Important Notes

1. Aggregate Functions: Any column in the SELECT statement that is not an aggregate function must be included in the GROUP BY clause.
 
2. HAVING Clause: You can filter groups using the HAVING clause, which is similar to the WHERE clause but is used for aggregated data. For example:

  

   SELECT department, COUNT(*) AS employee_count
   FROM employees
   GROUP BY department
   HAVING COUNT(*) > 1;
   

   This would return only departments with more than one employee.

▎Conclusion

The GROUP BY clause is a powerful tool in SQL for summarizing data. It allows you to analyze and report on your datasets effectively by grouping similar data points and applying aggregate functions.

𝗦𝗤𝗟 𝗠𝘂𝘀𝘁-𝗞𝗻𝗼𝘄 𝗗𝗶𝗳𝗳𝗲𝗿𝗲𝗻𝗰𝗲𝘀 📊

Whether you're writing daily queries or preparing for interviews, understanding these subtle SQL differences can make a big impact on both performance and accuracy.

🧠 Here’s a powerful visual that compares the most commonly misunderstood SQL concepts — side by side.

📌 𝗖𝗼𝘃𝗲𝗿𝗲𝗱 𝗶𝗻 𝘁𝗵𝗶𝘀 𝘀𝗻𝗮𝗽𝘀𝗵𝗼𝘁:
🔹 RANK() vs DENSE_RANK()
🔹 HAVING vs WHERE
🔹 UNION vs UNION ALL
🔹 JOIN vs UNION
🔹 CTE vs TEMP TABLE
🔹 SUBQUERY vs CTE
🔹 ISNULL vs COALESCE
🔹 DELETE vs DROP
🔹 INTERSECT vs INNER JOIN
🔹 EXCEPT vs NOT IN

React ♥️ for detailed post with examples

📍Honeywell is hiring for Software Engr I

Qualification: Bachelors Degree

Experience: 0-1 years 

Batch: 2025 / 2024 / 2023 / 2022

Salary: up to ₹6 - 13 LPA

Job Location: Madurai

🔗 𝗔𝗽𝗽𝗹𝘆 𝗛𝗲𝗿𝗲: https://techcompreviews.in/honeywell-off-campus-hiring-software-engineer/