🔟 How would you find duplicate records in SQL?

Sample Answer:

"I would first identify the column or combination of columns that should uniquely identify a record. Then I would use GROUP BY and HAVING COUNT(*) > 1."

SELECT Customer_ID, COUNT(*) AS Count_Records
FROM Customers
GROUP BY Customer_ID
HAVING COUNT(*) > 1;

"This identifies Customer_ID values that appear more than once. I would then investigate whether those records are genuine duplicates before taking any corrective action."

📌 Double Tap ❤️ For Part-3

📊 Data Analyst Interview Series — Part 3

Guys, let's continue our Data Analyst Interview Series.

Today, let's cover 10 important SQL interview questions that test your practical SQL knowledge. 👇

1️⃣ What is a subquery in SQL?

Sample Answer:

“A subquery is a query written inside another SQL query. It can be used to retrieve intermediate results that are then used by the outer query.

For example, to find employees whose salary is greater than the average salary:”

SELECT Employee_ID, Salary
FROM Employees
WHERE Salary > (
    SELECT AVG(Salary)
    FROM Employees
);

2️⃣ What is a CTE?

Sample Answer:

“CTE stands for Common Table Expression. It allows us to define a temporary named result set using the WITH clause, which can then be referenced within the main query.

CTEs make complex queries easier to read, maintain, and debug.”

WITH CustomerSales AS (
    SELECT Customer_ID,
           SUM(Sales) AS Total_Sales
    FROM Sales
    GROUP BY Customer_ID
)
SELECT *
FROM CustomerSales
WHERE Total_Sales > 100000;

3️⃣ What is a window function?

Sample Answer:

“A window function performs a calculation across a set of related rows while still retaining the individual rows in the result.

Unlike GROUP BY, it does not collapse multiple rows into a single row.

Common window functions include ROW_NUMBER(), RANK(), DENSE_RANK(), LAG(), and LEAD().”

4️⃣ What is the difference between RANK(), DENSE_RANK(), and ROW_NUMBER()?

Sample Answer:

“ROW_NUMBER() assigns a unique sequential number to every row.

RANK() assigns the same rank to tied values but leaves gaps after a tie.

DENSE_RANK() also assigns the same rank to tied values but does not leave gaps.”

Example:

Values: 100, 100, 90

ROW_NUMBER: 1, 2, 3

RANK: 1, 1, 3

DENSE_RANK: 1, 1, 2

5️⃣ How would you find the second-highest salary?

Sample Answer:

“One approach is to use DENSE_RANK(). This also handles duplicate salaries correctly.”

WITH RankedEmployees AS (
    SELECT Employee_ID,
           Salary,
           DENSE_RANK() OVER (ORDER BY Salary DESC) AS Salary_Rank
    FROM Employees
)
SELECT Employee_ID, Salary
FROM RankedEmployees
WHERE Salary_Rank = 2;

6️⃣ How would you find the top 3 salaries in each department?

Sample Answer:

“I would use a window function to rank employees within each department.”

WITH RankedEmployees AS (
    SELECT Employee_ID,
           Department,
           Salary,
           DENSE_RANK() OVER (
               PARTITION BY Department
               ORDER BY Salary DESC
           ) AS Salary_Rank
    FROM Employees
)
SELECT *
FROM RankedEmployees
WHERE Salary_Rank <= 3;

“The PARTITION BY ensures that ranking starts separately for each department.”

7️⃣ What is PARTITION BY in SQL?

Sample Answer:

“PARTITION BY divides the result set into groups for a window function without collapsing the rows.

For example, if I want to rank employees separately within each department, I can use PARTITION BY Department.”

SELECT Employee_ID,
       Department,
       Salary,
       RANK() OVER (
           PARTITION BY Department
           ORDER BY Salary DESC
       ) AS Salary_Rank
FROM Employees;

8️⃣ What are LAG() and LEAD() functions?

Sample Answer:

“LAG() allows me to access a value from a previous row, while LEAD() allows me to access a value from a following row.

They are particularly useful for comparing current values with previous or future values, such as month-over-month sales.”

SELECT Month,
       Sales,
       LAG(Sales) OVER (ORDER BY Month) AS Previous_Month_Sales
FROM Monthly_Sales;

9️⃣ How would you calculate month-over-month growth?

Sample Answer:

“I would first retrieve the previous month's sales using LAG(), then calculate the percentage change between the current month and previous month.”

SELECT Month,
       Sales,
       LAG(Sales) OVER (ORDER BY Month) AS Previous_Sales,
       (Sales - LAG(Sales) OVER (ORDER BY Month))
       * 100.0 /
       LAG(Sales) OVER (ORDER BY Month) AS MoM_Growth
FROM Monthly_Sales;

“I would also handle cases where the previous month's value is zero or NULL to avoid incorrect calculations.”

🔟 What is the difference between DELETE, TRUNCATE, and DROP?

Sample Answer:

“DELETE removes selected rows from a table and can be used with a WHERE condition.

TRUNCATE removes all rows from a table while keeping the table structure.

DROP removes the entire table, including its structure and data.

So, the key difference is whether I'm removing specific records, all records, or the entire table itself.”

📌 Double Tap ❤️ For Part-4

𝗠𝗮𝘀𝘁𝗲𝗿 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 𝗳𝗼𝗿 𝗙𝗥𝗘𝗘! 🔥

Learn Power BI through these FREE learning resources
​
✨ What You'll Learn:
📊 Interactive Dashboards
📈 Data Visualization
🧹 Data Transformation
💼 Real-World Reporting Skills
🎯 Beginner-Friendly — No Coding Required

𝗦𝘁𝗮𝗿𝘁 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴 𝗳𝗼𝗿 𝗙𝗥𝗘𝗘
​
​https://pdlink.in/4hznwlu

💫Perfect for Students • Freshers • Data Analyst Aspirants • Working Professionals

📊 Data Analyst Interview Series — Part 4

Guys, let's continue our Data Analyst Interview Series.

Today, let's cover 10 practical SQL questions that are commonly asked in Data Analyst interviews. 👇

1️⃣ How do you find the highest salary in each department?

Sample Answer:

"I would use a window function such as DENSE_RANK() and partition the data by department."

WITH RankedEmployees AS (
    SELECT Employee_ID,
           Department,
           Salary,
           DENSE_RANK() OVER (
               PARTITION BY Department
               ORDER BY Salary DESC
           ) AS Salary_Rank
    FROM Employees
)
SELECT Employee_ID, Department, Salary
FROM RankedEmployees
WHERE Salary_Rank = 1;

2️⃣ How do you find customers who have never placed an order?

Sample Answer:

"I would use a LEFT JOIN between the Customers and Orders tables and then filter for customers where no matching order exists."

SELECT c.Customer_ID,
       c.Customer_Name
FROM Customers c
LEFT JOIN Orders o
    ON c.Customer_ID = o.Customer_ID
WHERE o.Customer_ID IS NULL;

3️⃣ How do you find the total sales for each customer?

Sample Answer:

"I would group the sales data by Customer_ID and use SUM() to calculate the total sales."

SELECT Customer_ID,
       SUM(Sales) AS Total_Sales
FROM Orders
GROUP BY Customer_ID;

4️⃣ How do you find the top 5 customers by sales?

Sample Answer:

"I would aggregate sales by customer, sort the result in descending order, and then return the top five customers."

SELECT Customer_ID,
       SUM(Sales) AS Total_Sales
FROM Orders
GROUP BY Customer_ID
ORDER BY Total_Sales DESC
LIMIT 5;

"The exact syntax for limiting rows can vary depending on the database, such as TOP in SQL Server."

5️⃣ How do you calculate the average order value?

Sample Answer:

"Average Order Value can be calculated by dividing total sales by the number of orders. If each row represents one order, AVG() can also be used directly on the order amount."

SELECT AVG(Order_Amount) AS Average_Order_Value
FROM Orders;

6️⃣ How would you identify customers who placed more than 5 orders?

Sample Answer:

"I would group the orders by Customer_ID and use HAVING to filter customers whose order count is greater than five."

SELECT Customer_ID,
       COUNT(**) AS Order_Count
FROM Orders
GROUP BY Customer_ID
HAVING COUNT(**) > 5;

7️⃣ How do you find records from the last 30 days?

Sample Answer:

"I would compare the date column with the current date and subtract 30 days. The exact syntax depends on the database."

For example:

SELECT **
FROM Orders
WHERE Order_Date >= CURRENT_DATE - INTERVAL '30' DAY;

8️⃣ How do you find the total sales by month?

Sample Answer:

"I would extract the month from the order date, group the data by month, and calculate the total sales."

SELECT
    DATE_TRUNC('month', Order_Date) AS Month,
    SUM(Sales) AS Total_Sales
FROM Orders
GROUP BY DATE_TRUNC('month', Order_Date)
ORDER BY Month;

9️⃣ How do you find employees whose salary is above their department's average salary?

Sample Answer:

"I would calculate the average salary for each department and compare each employee's salary with that department-level average. A CTE makes this easier to read."

WITH DepartmentAverage AS (
    SELECT Department,
           AVG(Salary) AS Avg_Salary
    FROM Employees
    GROUP BY Department
)
SELECT e.Employee_ID,
       e.Department,
       e.Salary
FROM Employees e
JOIN DepartmentAverage d
    ON e.Department = d.Department
WHERE e.Salary > d.Avg_Salary;

🔟 What is the difference between UNION and JOIN?

Sample Answer:

"JOIN combines columns from different tables based on a related key.

UNION combines rows from the results of two SELECT statements with compatible column structures.

For example, if I want to combine customer information with order information, I would typically use a JOIN. If I want to append two similar datasets containing the same type of records, I might use UNION."

📌 Double Tap ❤️ For Part 5

🚀𝗣𝗮𝘆 𝗔𝗳𝘁𝗲𝗿 𝗣𝗹𝗮𝗰𝗲𝗺𝗲𝗻𝘁 𝗧𝗿𝗮𝗶𝗻𝗶𝗻𝗴 | 𝗕𝗲𝗰𝗼𝗺𝗲 𝗮 𝗙𝘂𝗹𝗹𝘀𝘁𝗮𝗰𝗸 𝗗𝗲𝘃𝗲𝗹𝗼𝗽𝗲𝗿 𝗪𝗜𝘁𝗵 𝗚𝗲𝗻𝗔𝗜

Start a high-paying tech career—even without prior coding experience

🏆 𝗣𝗹𝗮𝗰𝗲𝗺𝗲𝗻𝘁 𝗛𝗶𝗴𝗵𝗹𝗶𝗴𝗵𝘁𝘀:
💰 ₹41 LPA highest salary
📈 ₹7.4 LPA average salary
🎓 2,000+ students placed
🏢 500+ hiring partners
✅ 100% job assistance
📜 Skill India–authenticated certificate

🔗 𝗔𝗽𝗽𝗹𝘆 𝗡𝗼𝘄👇:-

https://pdlink.in/3SuUeuD

🎯 HurryUp.....Limited Seats Available

📊 Data Analyst Interview Series — Part 5

Guys, let's continue our Data Analyst Interview Series.

This time, let's move to one of the most important skills for a Data Analyst: Excel.

Here are 10 Excel interview questions you should know. 👇

1️⃣ What is a PivotTable and why is it used?

Sample Answer:

“A PivotTable is an Excel feature used to quickly summarize and analyze large datasets. It allows me to group, filter, and aggregate data without writing complex formulas.

For example, I can use a PivotTable to calculate total sales by region, product, or month and quickly identify business trends.”

2️⃣ What is the difference between VLOOKUP and XLOOKUP?

Sample Answer:

“VLOOKUP searches for a value in the first column of a selected range and returns a value from another column. It has limitations such as primarily working from left to right.

XLOOKUP is more flexible. It can search in any direction, provides better handling of missing values, and allows separate lookup and return ranges.

For new Excel work, I would generally prefer XLOOKUP when it is available.”

3️⃣ What is the difference between COUNT, COUNTA, COUNTIF, and COUNTIFS?

Sample Answer:

“COUNT counts cells containing numbers.

COUNTA counts non-empty cells.

COUNTIF counts cells that meet one condition.

COUNTIFS counts cells that meet multiple conditions.”

Example:

=COUNT(A2:A100)

=COUNTA(A2:A100)

=COUNTIF(B2:B100,"Completed")

=COUNTIFS(B2:B100,"Completed",C2:C100,">1000")

4️⃣ What is the difference between SUMIF and SUMIFS?

Sample Answer:

“SUMIF is used when I have one condition, while SUMIFS is used when I need to apply multiple conditions.

For example, to calculate sales for the India region:

=SUMIF(A:A,"India",B:B)

To calculate sales for India where the product is Laptop:

=SUMIFS(C:C,A:A,"India",B:B,"Laptop")

5️⃣ How do you remove duplicate records in Excel?

Sample Answer:

“I first determine which columns should uniquely identify a record. Then I can use Excel's Remove Duplicates feature to identify and remove duplicate rows.

However, I would not immediately delete duplicates. I would first verify whether they are genuine duplicates or legitimate repeated transactions.”

6️⃣ How do you handle missing values in Excel?

Sample Answer:

“First, I identify how many values are missing and understand why they are missing.

Depending on the situation, I may replace them with an appropriate value, use a formula such as IF or IFERROR, flag them as ‘Unknown’, or exclude them if the business requirement allows it.

I would avoid blindly replacing missing values because that can affect the accuracy of the analysis.”

7️⃣ What is conditional formatting?

Sample Answer:

“Conditional formatting automatically changes the appearance of cells based on specified conditions.

For example, I can use it to highlight sales below target, overdue transactions, duplicate values, negative profit, or unusually high values.

It is useful for quickly identifying patterns and exceptions in a dataset.”

8️⃣ How would you identify the top 10 customers by sales in Excel?

Sample Answer:

“I could use a PivotTable to summarize total sales by customer, sort the values in descending order, and filter the result to the top 10 customers.

Alternatively, depending on the Excel version and requirement, I could use functions such as SORT, FILTER, or LARGE.”

9️⃣ What is the difference between relative and absolute cell references?

Sample Answer:

“A relative reference changes when a formula is copied to another cell.

For example:

=A2**B2

An absolute reference remains fixed when the formula is copied.

For example:

=A2**$B$1

Absolute references are particularly useful when applying a calculation using a fixed assumption, tax rate, exchange rate, or target value.”

🔟 How would you clean a large dataset in Excel?

Sample Answer:

“I would first understand the structure and identify data-quality issues.

My process would typically include:

• Removing or investigating duplicates

• Handling missing values

• Standardizing text and date formats

• Correcting inconsistent values

• Checking data types

• Identifying invalid or unusual values

• Using formulas or Power Query for repeatable transformations

• Validating the cleaned dataset before analysis

For a large or recurring dataset, I would prefer Power Query rather than manually cleaning the data every time.”

Double Tap ❤️ For Part-6

📊 Kandinsky 6.0 Video: AI-Powered Content Creation for Analysts

The new Kandinsky 6.0 Video lineup — the flagship Pro and the lightweight Lite — generates videos with synchronized audio in quality up to Full HD: useful for data storytelling and presentations. Open-source under the MIT license.

🎯 Key capabilities for analysts:
• Create video reports with voiceover narration
• Animate data visualizations with background music
• Generate demo clips for stakeholder presentations
• Produce training videos with synchronized explanations

📈 Technical details:
• Video + audio generation in one model
• Lip-sync for spokesperson videos
• 44 kHz audio quality
• Realistic physics in animations
• Up to 5 seconds per clip

🔧 Integration:
Open-source (MIT license). Works with:
• Diffusers (Python)
• FastVideo
• ComfyUI

📊 Performance:
• Clearly outperforms the previous version across all criteria (Pro)
• Pro beats Veo 3.1 Fast in image animation

Anton Frolov, Sber: "For professional content, this means faster and more cost-effective production."

🔗 Hugging Face

🎓 𝗠𝗶𝗰𝗿𝗼𝘀𝗼𝗳𝘁 𝗙𝗥𝗘𝗘 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝘄𝗶𝘁𝗵 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗲𝘀! 🚀🔥

Upgrade your resume with Microsoft learning opportunities. Explore courses covering some of today's most in-demand tech skills!

🎯 Perfect for Students • Freshers • Job Seekers • Working Professionals

✅ Learn at your own pace ✅ Build career-relevant skills ✅ Explore available certificates and credentials

🔗 𝗔𝗰𝗰𝗲𝘀𝘀 𝗠𝗶𝗰𝗿𝗼𝘀𝗼𝗳𝘁 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝗛𝗲𝗿𝗲 👇

https://pdlink.in/3Uf5trR

🔥 Share with friends looking to upskill in 2026!