✅ SQL Coding Interview Questions with Answers: Part 4 📘💻

1️⃣ Retrieve Employees with the Highest Salary in Each Department (Full Details)
Table: Employees
Columns: id, name, dept, salary

SELECT *
FROM Employees e
WHERE salary = (
  SELECT MAX(salary)
  FROM Employees
  WHERE dept = e.dept
);

🧠 _Use case:_ Get full employee details, not just the salary, for top earners per department.

2️⃣ Find Departments Without Employees
Tables: Departments (id, name), Employees (id, name, dept_id)

SELECT d.*
FROM Departments d
LEFT JOIN Employees e ON d.id = e.dept_id
WHERE e.id IS NULL;

🧠 _Use case:_ Identify departments that haven’t been staffed yet.

3️⃣ Rank Employees by Salary Within Department (With Ties)
Table: Employees

SELECT id, name, dept, salary,
RANK() OVER (PARTITION BY dept ORDER BY salary DESC) AS salary_rank
FROM Employees;

🧠 _Use case:_ Useful for performance reviews or compensation analysis.

4️⃣ Find Consecutive Login Days Per User
Table: Logins (user_id, login_date)

SELECT user_id, login_date,
       DATEDIFF(login_date,
         ROW_NUMBER() OVER (PARTITION BY user_id ORDER BY login_date)) AS grp
FROM Logins;

🧠 _Use case:_ Group by user_id and grp to find streaks of consecutive logins.

5️⃣ Get Employees with the Minimum Salary in the Company
Table: Employees

SELECT *
FROM Employees
WHERE salary = (SELECT MIN(salary) FROM Employees);

🧠 _Use case:_ Identify underpaid or entry-level employees.

6️⃣ Find Managers Who Don’t Have Any Direct Reports
Table: Employees (id, name, manager_id)

SELECT *
FROM Employees
WHERE id NOT IN (
  SELECT DISTINCT manager_id
  FROM Employees
  WHERE manager_id IS NOT NULL
);

🧠 Use case: Spot inactive or placeholder managers.

💬 Double Tap ❤️ For More

Most Asked SQL Interview Questions at MAANG Companies🔥🔥

Preparing for an SQL Interview at MAANG Companies? Here are some crucial SQL Questions you should be ready to tackle:

1. How do you retrieve all columns from a table?

SELECT * FROM table_name;

2. What SQL statement is used to filter records?

SELECT * FROM table_name
WHERE condition;

The WHERE clause is used to filter records based on a specified condition.

3. How can you join multiple tables? Describe different types of JOINs.

SELECT columns
FROM table1
JOIN table2 ON table1.column = table2.column
JOIN table3 ON table2.column = table3.column;

Types of JOINs:

1. INNER JOIN: Returns records with matching values in both tables

SELECT * FROM table1
INNER JOIN table2 ON table1.column = table2.column;

2. LEFT JOIN: Returns all records from the left table & matched records from the right table. Unmatched records will have NULL values.

SELECT * FROM table1
LEFT JOIN table2 ON table1.column = table2.column;

3. RIGHT JOIN: Returns all records from the right table & matched records from the left table. Unmatched records will have NULL values.

SELECT * FROM table1
RIGHT JOIN table2 ON table1.column = table2.column;

4. FULL JOIN: Returns records when there is a match in either left or right table. Unmatched records will have NULL values.

SELECT * FROM table1
FULL JOIN table2 ON table1.column = table2.column;

4. What is the difference between WHERE & HAVING clauses?

WHERE: Filters records before any groupings are made.

SELECT * FROM table_name
WHERE condition;

HAVING: Filters records after groupings are made.

SELECT column, COUNT(*)
FROM table_name
GROUP BY column
HAVING COUNT(*) > value;

5. How do you calculate average, sum, minimum & maximum values in a column?

Average: SELECT AVG(column_name) FROM table_name;

Sum: SELECT SUM(column_name) FROM table_name;

Minimum: SELECT MIN(column_name) FROM table_name;

Maximum: SELECT MAX(column_name) FROM table_name;

Here you can find essential SQL Interview Resources👇
https://t.iss.one/mysqldata

Like this post if you need more 👍❤️

Hope it helps :)

✅ Top SQL Queries: Part-1 🧠💻

1️⃣ SELECT – Retrieve Data
🔹 Use case: Show all employees
SELECT * FROM employees;

2️⃣ WHERE – Filter Data
🔹 Use case: Get employees from ‘Sales’ department
SELECT name FROM employees WHERE department = 'Sales';

3️⃣ ORDER BY – Sort Results
🔹 Use case: List products by price (low to high)
SELECT product_name, price FROM products ORDER BY price ASC;

4️⃣ GROUP BY – Aggregate Data
🔹 Use case: Count employees in each department
SELECT department, COUNT(*) FROM employees GROUP BY department;

5️⃣ JOIN – Combine Tables
🔹 Use case: Show orders with customer names
SELECT o.order_id, c.customer_name
FROM orders o
JOIN customers c ON o.customer_id = c.id;

6️⃣ INSERT – Add New Records
🔹 Use case: Add a new product
INSERT INTO products (name, price, category)
VALUES ('Headphones', 1500, 'Electronics');

7️⃣ UPDATE – Modify Existing Records
🔹 Use case: Change price of 'Headphones'
UPDATE products SET price = 1700 WHERE name = 'Headphones';

8️⃣ DELETE – Remove Data
🔹 Use case: Delete users inactive for 1 year
DELETE FROM users WHERE last_login < '2024-01-01';

9️⃣ LIKE – Pattern Matching
🔹 Use case: Find customers whose names start with 'A'
SELECT * FROM customers WHERE name LIKE 'A%';

🔟 LIMIT – Restrict Output
🔹 Use case: Show top 3 most expensive items
SELECT name, price FROM products ORDER BY price DESC LIMIT 3;

💬 Tap ❤️ for Part 2!

🚀 Roadmap to Master SQL in 30 Days! 🗃️🧠

📅 Week 1: SQL Basics
🔹 Day 1–2: What is SQL? DBMS vs RDBMS
🔹 Day 3–5: SELECT, WHERE, ORDER BY, LIMIT
🔹 Day 6–7: Filtering with AND, OR, IN, NOT, BETWEEN

📅 Week 2: Intermediate SQL
🔹 Day 8–9: Functions (COUNT, SUM, AVG, MIN, MAX)
🔹 Day 10–11: GROUP BY, HAVING
🔹 Day 12–14: JOINS (INNER, LEFT, RIGHT, FULL)

📅 Week 3: Advanced SQL
🔹 Day 15–17: Subqueries Nested Queries
🔹 Day 18–20: CASE statements, COALESCE, NULL handling
🔹 Day 21–22: Window Functions (ROW_NUMBER, RANK, PARTITION BY)

📅 Week 4: Practical Use Projects
🔹 Day 23–25: Views, Indexes, Stored Procedures (basic)
🔹 Day 26–28: Real-world project (e.g., Sales dashboard with queries)
🔹 Day 29–30: Practice on platforms like LeetCode, HackerRank, Mode

💡 Bonus Tools:
• MySQL / PostgreSQL / SQLite
• DB Fiddle / SQLZoo / W3Schools
• Power BI / Excel for data connection

💬 Tap ❤️ for more!

Today, let's start with the complete SQL series starting with the basics:

✅ SQL Basics: Part-1 🧠💾

SQL (Structured Query Language) is the standard language used to communicate with databases.
You use it to store, retrieve, update, and delete data in a structured format.

🛠️ Why Learn SQL?
• It’s used in data analytics, development, and business intelligence.
• Works with tools like Power BI, Excel, Python, Tableau, etc.
• Helps in querying and analyzing large datasets efficiently.

📚 Key Concepts:

1️⃣ DBMS (Database Management System)
• A software to manage databases.
• Stores data in files or documents.
• Examples: Microsoft Access, MongoDB (non-relational).
• No strict structure or rules.

2️⃣ RDBMS (Relational Database Management System)
• Stores data in tables with rows and columns.
• Ensures data consistency using relationships.
• Follows ACID properties (Atomicity, Consistency, Isolation, Durability).
• Examples: MySQL, PostgreSQL, Oracle, SQL Server.

🗂️ Simple Table Example (in RDBMS):

Customers Table

You can use SQL to:
SELECT * FROM Customers;
➡️ This returns all records from the table. (Note: The * here is a wildcard meaning "all columns").

🔁 Real-life Analogy:
Think of RDBMS as Excel — rows are records, columns are fields.
SQL is the language to ask questions like:
- Who are my customers from Delhi?
- What is the total number of orders last month?

🎯 Task for You Today:
✅ Install MySQL or use an online SQL editor (like SQLFiddle)
✅ Learn basic syntax: SELECT, FROM
✅ Try creating a sample table and selecting data

💬 Tap ❤️ for Part-2

✅ SQL Basics: Part-2 (SQL Commands) 🧠💾

1️⃣ SELECT – Pull data from a table
_Syntax:_

SELECT column1, column2 FROM table_name;

_Example:_

SELECT name, city FROM customers;

To get _everything_ use:

SELECT * FROM customers;

2️⃣ WHERE – Filter specific rows
_Syntax:_

SELECT columns FROM table_name WHERE condition;

_Example:_

SELECT name FROM customers WHERE city = 'Delhi';

_Operators you can use:_
• =, !=, >, <, >=, <=
• LIKE (pattern match)
• BETWEEN, IN, IS NULL

3️⃣ ORDER BY – Sort results
_Syntax:_

SELECT columns FROM table_name ORDER BY column ASC|DESC;

_Example:_

SELECT name, age FROM employees ORDER BY age DESC;

4️⃣ LIMIT – Restrict number of results
_Syntax:_

SELECT columns FROM table_name LIMIT number;

_Example:_

SELECT * FROM products LIMIT 5;

🔥 _Quick Practice Task:_
Write a query to:
• Get top 10 highest-paid employees in 'Marketing'
• Show name, salary, and department
• Sort salary high to low:

SELECT name, salary, department
FROM employees
WHERE department = 'Marketing'
ORDER BY salary DESC
LIMIT 10;

✅ SQL Interview QA 💼🧠

Q1. What does the SELECT statement do in SQL?
_Answer:_
It retrieves data from one or more columns in a table.

SELECT name, city FROM customers;

Q2. How would you fetch all the columns from a table?
_Answer:_
Use SELECT * to get every column.

SELECT * FROM orders;

Q3. What’s the difference between WHERE and HAVING?
_Answer:_
• WHERE filters rows _before_ grouping
• HAVING filters _after_ GROUP BY
You use WHERE with raw data, HAVING with aggregated data.

Q4. Write a query to find all products with price > 500.
_Answer:_

SELECT * FROM products WHERE price > 500;

Q5. How do you sort data by two columns?
_Answer:_
Use ORDER BY col1, col2.

SELECT name, department FROM employees ORDER BY department ASC, name ASC;

Q6. What does LIMIT 1 do in a query?
_Answer:_
It returns only the _first row_ of the result.

SELECT * FROM customers ORDER BY created_at DESC LIMIT 1;

Q7. Write a query to get names of top 5 students by marks.
_Answer:_

SELECT name, marks
FROM students
ORDER BY marks DESC
LIMIT 5;

Q8. Can you use ORDER BY without WHERE?
_Answer:_
Yes. ORDER BY works independently. It sorts all data unless filtered with WHERE.

💡 _Pro Tip:_
In interviews, they may ask you to _write queries live_ or explain the _output_ of a query. Stay calm, read the structure carefully, and _think in steps_.

DOUBLE TAP ❤️ FOR MORE

✅ SQL Basics: Part-3: Filtering with SQL Operators

Filtering helps you narrow down results based on specific conditions.

Let’s explore some powerful SQL operators:

1️⃣ IN – Match multiple values
Syntax:

SELECT columns FROM table_name WHERE column IN (value1, value2,...);

Example:
Get customers from specific cities:

SELECT name, city FROM customers
WHERE city IN ('Delhi', 'Mumbai', 'Chennai');

2️⃣ OR – Match any of multiple conditions
Syntax:

SELECT columns FROM table_name WHERE condition1 OR condition2;

Example:
Get employees from HR or Finance:

SELECT name FROM employees
WHERE department = 'HR' OR department = 'Finance';

3️⃣ AND – Match all conditions
Syntax:

SELECT columns FROM table_name WHERE condition1 AND condition2;

Example:
Get Sales employees earning more than 60,000:

SELECT name FROM employees
WHERE department = 'Sales' AND salary > 60000;

4️⃣ NOT – Exclude specific values or conditions
Syntax:

SELECT columns FROM table_name WHERE NOT condition;

Example:
Get all products except Electronics:

SELECT * FROM products
WHERE NOT category = 'Electronics';

5️⃣ BETWEEN – Match a range of values (inclusive)
Syntax:

SELECT columns FROM table_name WHERE column BETWEEN value1 AND value2;

Example:
Get employees with salary between 50,000 and 100,000:

SELECT name, salary FROM employees
WHERE salary BETWEEN 50000 AND 100000;

🔥 Quick Practice Task:
Write a query to:
• Get all employees in 'IT' or 'HR'
• Who earn more than 50,000
• Show name, department, and salary:

SELECT name, department, salary
FROM employees
WHERE department IN ('IT', 'HR')
AND salary > 50000;

✅ SQL Filtering Interview QA 💼🧠

Q1. What’s the difference between AND and OR?
A:
• AND requires all conditions to be true
• OR requires at least one condition to be true

Q2. Can you combine AND and OR in one query?
A: Yes, but use parentheses to control logic:

SELECT * FROM employees
WHERE (department = 'Sales' OR department = 'Marketing')
AND salary > 60000;

Q3. What does NOT IN do?
A: Excludes rows with values in the list:

SELECT * FROM customers
WHERE city NOT IN ('Delhi', 'Mumbai');

Q4. Can BETWEEN be used with dates?
A: Absolutely!

SELECT * FROM orders
WHERE order_date BETWEEN '2025-01-01' AND '2025-01-31';

Q5. What’s the difference between IN and multiple ORs?
A: IN is cleaner and more concise:
-- Instead of:

WHERE city = 'A' OR city = 'B' OR city = 'C';

-- Use:

WHERE city IN ('A', 'B', 'C');

💡 Pro Tip:
When combining multiple filters, always use parentheses to avoid unexpected results due to operator precedence.

SQL Roadmap

DOUBLE TAP ❤️ FOR MORE

✅ SQL Functions 📊🧠

SQL functions are built-in operations used to manipulate, calculate, and transform data. They help in summarizing results, formatting values, and applying logic in queries.

1️⃣ Aggregate Functions
These return a single result from a group of rows.

• COUNT() – Counts rows
SELECT COUNT(*) FROM employees;

• SUM() – Adds values
SELECT SUM(salary) FROM employees WHERE department = 'IT';

• AVG() – Returns average
SELECT AVG(age) FROM customers;

• MAX() / MIN() – Highest or lowest value
SELECT MAX(salary), MIN(salary) FROM employees;

2️⃣ String Functions

• UPPER() / LOWER() – Change case
SELECT UPPER(name), LOWER(city) FROM customers;

• CONCAT() – Join strings
SELECT CONCAT(first_name, ' ', last_name) AS full_name FROM users;

• SUBSTRING() – Extract part of a string
SELECT SUBSTRING(name, 1, 3) FROM products;

• LENGTH() – Length of string
SELECT LENGTH(description) FROM products;

3️⃣ Date Functions

• CURRENT_DATE / NOW() – Current date/time
SELECT CURRENT_DATE, NOW();

• DATE_ADD() / DATE_SUB() – Add or subtract days
SELECT DATE_ADD(hire_date, INTERVAL 30 DAY) FROM employees;

• DATEDIFF() – Difference between dates
SELECT DATEDIFF(end_date, start_date) FROM projects;

• YEAR() / MONTH() / DAY() – Extract parts
SELECT YEAR(order_date), MONTH(order_date) FROM orders;

4️⃣ Mathematical Functions

• ROUND() – Round decimals
SELECT ROUND(price, 2) FROM products;

• CEIL() / FLOOR() – Round up/down
SELECT CEIL(4.2), FLOOR(4.8);

• ABS() – Absolute value
SELECT ABS(balance) FROM accounts;

5️⃣ Conditional Function

• COALESCE() – Returns first non-null value
SELECT COALESCE(phone, 'Not Provided') FROM customers;

• CASE – If/else logic in SQL

  SELECT name,  
    CASE  
      WHEN salary > 50000 THEN 'High'  
      WHEN salary BETWEEN 30000 AND 50000 THEN 'Medium'  
      ELSE 'Low'  
    END AS salary_band  
  FROM employees;
  

🎯 Use These Functions To:
• Summarize data
• Clean and format strings
• Handle nulls
• Calculate time differences
• Add logic into queries

💬 Tap ❤️ for more!

✅ SQL GROUP BY HAVING 📊

What is GROUP BY?
GROUP BY is used to group rows that have the same values in one or more columns. It’s mostly used with aggregate functions like SUM(), COUNT(), AVG() to get summarized results.

What is HAVING?
HAVING is like WHERE, but it works after grouping. It filters the grouped results. You can’t use aggregate functions in WHERE, so we use HAVING instead.

📌 Problem 1:
You want to find total sales made in each city.

SELECT city, SUM(sales) AS total_sales  
FROM customers  
GROUP BY city;

✅ This groups the sales by city and shows total per group.

📌 Problem 2:
Now, show only those cities where total sales are above ₹50,000.

SELECT city, SUM(sales) AS total_sales  
FROM customers  
GROUP BY city  
HAVING total_sales > 50000;

✅ `HAVING filters the result after grouping.

📌 Problem 3:
Find departments with more than 10 active employees.

SELECT department, COUNT(*) AS emp_count  
FROM employees  
WHERE active = 1  
GROUP BY department  
HAVING emp_count > 10;

✅ First, we filter rows using WHERE. Then group, then filter groups with HAVING.

💡 Use GROUP BY to summarize, HAVING to filter those summaries.

Double Tap ♥️ For More

✅ SQL JOINS 🔗📘

JOINS let you combine data from two or more tables based on related columns.

1️⃣ INNER JOIN
Returns only matching rows from both tables.

Problem: Get customers with their orders.

SELECT c.name, o.order_id  
FROM customers c  
INNER JOIN orders o ON c.id = o.customer_id;

✅ Only shows customers who have orders.

2️⃣ LEFT JOIN (or LEFT OUTER JOIN)
Returns all rows from the left table + matching rows from the right table. If no match, fills with NULL.

Problem: Show all customers, even if they didn’t order.

SELECT c.name, o.order_id  
FROM customers c  
LEFT JOIN orders o ON c.id = o.customer_id;

✅ Includes customers without orders.

3️⃣ RIGHT JOIN
Opposite of LEFT JOIN: keeps all rows from the right table.

4️⃣ FULL OUTER JOIN
Returns all rows from both tables. Where there’s no match, it shows NULL.

SELECT c.name, o.order_id  
FROM customers c  
FULL OUTER JOIN orders o ON c.id = o.customer_id;

✅ Includes customers with or without orders and orders with or without customers.

5️⃣ SELF JOIN
Table joins with itself.

Problem: Show employees and their managers.

SELECT e.name AS employee, m.name AS manager  
FROM employees e
JOIN employees m ON e.manager_id = m.id;

✅ Links each employee to their manager using a self join.

💡 Quick Summary:
• INNER JOIN → Only matches
• LEFT JOIN → All from left + matches
• RIGHT JOIN → All from right + matches
• FULL OUTER JOIN → Everything
• SELF JOIN → Table joins itself

💬 Tap ❤️ for more!

✅ SQL Subqueries & Nested Queries 🧠🔍

Subqueries help you write powerful queries inside other queries. They're useful when you need intermediate results.

1️⃣ What is a Subquery?
A subquery is a query inside () that runs first and passes its result to the outer query.

Example: Get employees who earn above average salary.

SELECT name, salary  
FROM employees  
WHERE salary > (SELECT AVG(salary) FROM employees);

✅ Subquery calculates average salary → main query finds those above it.

2️⃣ Subquery in SELECT Clause
You can use subqueries to return values in each row.

Example: Show employee names with department name.

SELECT name,  
  (SELECT dept_name FROM departments d WHERE d.id = e.dept_id) AS department  
FROM employees e;

3️⃣ Subquery in FROM Clause
Use when you want to filter or group temporary results.

Example: Get department-wise highest salary.

SELECT dept_id, MAX(salary)  
FROM (SELECT * FROM employees WHERE active = 1) AS active_emps  
GROUP BY dept_id;

4️⃣ Correlated Subquery
A subquery that uses a value from the outer query row.

Example: Get employees with highest salary in their department.

SELECT name, salary  
FROM employees e
WHERE salary = (SELECT MAX(salary) FROM employees WHERE dept_id = e.dept_id);

✅ Subquery runs for each row using outer query value.

💡 Real Use Cases:
• Filter rows based on dynamic conditions
• Compare values across groups
• Fetch related info in SELECT

🎯 Practice Tasks:
• Write a query to find 2nd highest salary
• Use subquery to get customers who placed more than 3 orders
• Create a nested query to show top-selling product per category


✅ Solution for Practice Tasks 👇

1️⃣ Find 2nd Highest Salary

SELECT MAX(salary) AS second_highest_salary  
FROM employees  
WHERE salary < (SELECT MAX(salary) FROM employees);

▶️ Finds the highest salary less than the max salary → gives the 2nd highest.


2️⃣ Customers Who Placed More Than 3 Orders

SELECT customer_id  
FROM orders  
GROUP BY customer_id  
HAVING COUNT(order_id) > 3;

▶️ Groups orders by customer and filters those with more than 3.

You can join to get customer names:

SELECT name  
FROM customers  
WHERE id IN (
  SELECT customer_id  
  FROM orders  
  GROUP BY customer_id  
  HAVING COUNT(order_id) > 3
);

3️⃣ Top-Selling Product Per Category

SELECT p.name, p.category_id, p.sales  
FROM products p  
WHERE p.sales = (
  SELECT MAX(sales)  
  FROM products  
  WHERE category_id = p.category_id
);

▶️ Correlated subquery finds the highest sales within each category.

💬 Tap ❤️ for more!

✅ SQL CASE Statement 🎯

The CASE statement lets you apply conditional logic inside SQL queries — like if/else in programming.

1️⃣ Basic CASE Syntax

SELECT name, salary,
  CASE  
    WHEN salary > 80000 THEN 'High'  
    WHEN salary BETWEEN 50000 AND 80000 THEN 'Medium'  
    ELSE 'Low'  
  END AS salary_level  
FROM employees;

✅ Categorizes salaries as High, Medium, or Low.

2️⃣ CASE in ORDER BY
Sort based on custom logic.

SELECT name, department  
FROM employees  
ORDER BY  
  CASE department  
    WHEN 'HR' THEN 1  
    WHEN 'Engineering' THEN 2  
    ELSE 3  
  END;

✅ HR shows up first, then Engineering, then others.

3️⃣ CASE in WHERE Clause
Control filtering logic conditionally.

SELECT *  
FROM orders  
WHERE status =  
  CASE  
    WHEN customer_type = 'VIP' THEN 'priority'  
    ELSE 'standard'  
  END;

4️⃣ Nested CASE (Advanced)

SELECT name, marks,  
  CASE  
    WHEN marks >= 90 THEN 'A'  
    WHEN marks >= 75 THEN  
      CASE WHEN marks >= 85 THEN 'B+' ELSE 'B' END  
    ELSE 'C'  
  END AS grade  
FROM students;

🎯 Use CASE When You Want To:
• Create labels or buckets
• Replace multiple IF conditions
• Make results more readable

📝 Practice Tasks:
1. Add a column that shows ‘Pass’ or ‘Fail’ based on marks
2. Create a salary band (Low/Medium/High) using CASE
3. Use CASE to sort products as 'Electronics' first, then 'Clothing'

💬 Tap ❤️ for more!

✅ SQL Programming: Handling NULL Values 🛠️

Missing data is common in databases. COALESCE() helps you fill in defaults and avoid null-related issues.

1️⃣ What is COALESCE?
Returns the first non-null value in a list.

SELECT name, COALESCE(phone, 'Not Provided') AS contact  
FROM customers;

✅ If phone is NULL, it shows ‘Not Provided’.

2️⃣ COALESCE with Calculations
Prevent nulls from breaking math.

SELECT name, salary, COALESCE(bonus, 0) AS bonus,  
       salary + COALESCE(bonus, 0) AS total_income  
FROM employees;

✅ If bonus is NULL, treat it as 0 to compute total.

3️⃣ Nested COALESCE
Use multiple fallback options.

SELECT name, COALESCE(email, alt_email, 'No Email') AS contact_email  
FROM users;

✅ Checks email, then alt_email, then default text.

4️⃣ COALESCE in WHERE clause
Filter even when data has nulls.

SELECT *  
FROM products  
WHERE COALESCE(category, 'Uncategorized') = 'Electronics';

🎯 Use COALESCE When You Want To:
• Replace NULLs with defaults
• Keep math & filters working
• Avoid errors in reports or dashboards

📝 Practice Tasks:
1. Replace nulls in city with ‘Unknown’
2. Show total amount = price + tax (tax may be null)
3. Replace nulls in description with ‘No Info Available’

✅ Solution for Practice Tasks 👇

1️⃣ Replace NULLs in city with 'Unknown'

SELECT name, COALESCE(city, 'Unknown') AS city  
FROM customers;

2️⃣ Show total amount = price + tax (tax may be NULL)

SELECT product_name, price, COALESCE(tax, 0) AS tax,  
       price + COALESCE(tax, 0) AS total_amount  
FROM products;

3️⃣ Replace NULLs in description with 'No Info Available'

SELECT product_name, COALESCE(description, 'No Info Available') AS description  
FROM products;

💬 Tap ❤️ for more!

✅ SQL Window Functions 🧠🪟

Window functions perform calculations across rows that are related to the current row — without collapsing the result like GROUP BY.

1️⃣ ROW_NUMBER() – Assigns a unique row number per partition

SELECT name, department,
  ROW_NUMBER() OVER (PARTITION BY department ORDER BY salary DESC) AS rank
FROM employees;

➤ Gives ranking within each department

2️⃣ RANK() & DENSE_RANK() – Ranking with gaps (RANK) or without gaps (DENSE_RANK)

SELECT name, salary,
  RANK() OVER (ORDER BY salary DESC) AS rank
FROM employees;

3️⃣ LAG() & LEAD() – Access previous or next row value

SELECT name, salary,
  LAG(salary) OVER (ORDER BY salary) AS prev_salary,
  LEAD(salary) OVER (ORDER BY salary) AS next_salary
FROM employees;

➤ Compare salary trends row-wise

4️⃣ SUM(), AVG(), COUNT() OVER() – Running totals, moving averages, etc.

SELECT department, salary,
  SUM(salary) OVER (PARTITION BY department) AS dept_total
FROM employees;

5️⃣ NTILE(n) – Divides rows into n equal buckets

SELECT name, salary,
  NTILE(4) OVER (ORDER BY salary DESC) AS quartile
FROM employees;

💡 Why Use Window Functions:
• Perform row-wise calculations
• Avoid GROUP BY limitations
• Enable advanced analytics (ranking, trends, etc.)

🧪 Practice Task:
Write a query to find the top 2 earners in each department using ROW_NUMBER().

💬 Tap ❤️ for more!

✅ SQL Real-World Use Cases 💼🧠

SQL is the backbone of data analysis and automation in many domains. Here’s how it powers real work:

1️⃣ Sales & CRM
Use Case: Sales Tracking & Pipeline Management
• Track sales per region, product, rep
• Identify top-performing leads
• Calculate conversion rates
SQL Task:

SELECT region, SUM(sales_amount)  
FROM deals  
GROUP BY region;

2️⃣ Finance
Use Case: Monthly Revenue and Expense Reporting
• Aggregate revenue by month
• Analyze profit margins
• Flag unusual transactions
SQL Task:

SELECT MONTH(date), SUM(revenue - expense) AS profit  
FROM finance_data  
GROUP BY MONTH(date);

3️⃣ HR Analytics
Use Case: Employee Attrition Analysis
• Track tenure, exits, departments
• Calculate average retention
• Segment by age, role, or location
SQL Task:

SELECT department, COUNT(*)  
FROM employees  
WHERE exit_date IS NOT NULL  
GROUP BY department;

4️⃣ E-commerce
Use Case: Customer Order Behavior
• Find most ordered products
• Time between repeat orders
• Cart abandonment patterns
SQL Task:

SELECT customer_id, COUNT(order_id)  
FROM orders  
GROUP BY customer_id  
HAVING COUNT(order_id) > 5;

5️⃣ Healthcare
Use Case: Patient Visit Frequency
• Find frequent visitors
• Analyze doctor performance
• Calculate average stay duration
SQL Task:

SELECT patient_id, COUNT(*) AS visits  
FROM appointments  
GROUP BY patient_id;

6️⃣ Marketing
Use Case: Campaign Performance by Channel
• Track leads, clicks, conversions
• Compare cost-per-lead by platform
SQL Task:

SELECT channel, SUM(conversions)/SUM(clicks) AS conv_rate  
FROM campaign_data  
GROUP BY channel;

🧪 Practice Task:
Pick a dataset (orders, users, sales)
→ Write 3 queries: summary, trend, filter
→ Visualize the output in Excel or Power BI

💬 Tap ❤️ for more!

✅ Useful Platform to Practice SQL Programming 🧠🖥️

Learning SQL is just the first step — practice is what builds real skill. Here are the best platforms for hands-on SQL:

1️⃣ LeetCode – For Interview-Oriented SQL Practice
• Focus: Real interview-style problems
• Levels: Easy to Hard
• Schema + Sample Data Provided
• Great for: Data Analyst, Data Engineer, FAANG roles
✔ Tip: Start with Easy → filter by “Database” tag
✔ Popular Section: Database → Top 50 SQL Questions
Example Problem: “Find duplicate emails in a user table” → Practice filtering, GROUP BY, HAVING

2️⃣ HackerRank – Structured & Beginner-Friendly
• Focus: Step-by-step SQL track
• Has certification tests (SQL Basic, Intermediate)
• Problem sets by topic: SELECT, JOINs, Aggregations, etc.
✔ Tip: Follow the full SQL track
✔ Bonus: Company-specific challenges
Try: “Revising Aggregations – The Count Function” → Build confidence with small wins

3️⃣ Mode Analytics – Real-World SQL in Business Context
• Focus: Business intelligence + SQL
• Uses real-world datasets (e.g., e-commerce, finance)
• Has an in-browser SQL editor with live data
✔ Best for: Practicing dashboard-level queries
✔ Tip: Try the SQL case studies & tutorials

4️⃣ StrataScratch – Interview Questions from Real Companies
• 500+ problems from companies like Uber, Netflix, Google
• Split by company, difficulty, and topic
✔ Best for: Intermediate to advanced level
✔ Tip: Try “Hard” questions after doing 30–50 easy/medium

5️⃣ DataLemur – Short, Practical SQL Problems
• Crisp and to the point
• Good UI, fast learning
• Real interview-style logic
✔ Use when: You want fast, smart SQL drills

📌 How to Practice Effectively:
• Spend 20–30 mins/day
• Focus on JOINs, GROUP BY, HAVING, Subqueries
• Analyze problem → write → debug → re-write
• After solving, explain your logic out loud

🧪 Practice Task:
Try solving 5 SQL questions from LeetCode or HackerRank this week. Start with SELECT, WHERE, and GROUP BY.

💬 Tap ❤️ for more!

✅ Data Analytics Roadmap for Freshers in 2025 🚀📊

1️⃣ Understand What a Data Analyst Does
🔍 Analyze data, find insights, create dashboards, support business decisions.

2️⃣ Start with Excel
📈 Learn:
– Basic formulas
– Charts & Pivot Tables
– Data cleaning
💡 Excel is still the #1 tool in many companies.

3️⃣ Learn SQL
🧩 SQL helps you pull and analyze data from databases.
Start with:
– SELECT, WHERE, JOIN, GROUP BY
🛠️ Practice on platforms like W3Schools or Mode Analytics.

4️⃣ Pick a Programming Language
🐍 Start with Python (easier) or R
– Learn pandas, matplotlib, numpy
– Do small projects (e.g. analyze sales data)

5️⃣ Data Visualization Tools
📊 Learn:
– Power BI or Tableau
– Build simple dashboards
💡 Start with free versions or YouTube tutorials.

6️⃣ Practice with Real Data
🔍 Use sites like Kaggle or Data.gov
– Clean, analyze, visualize
– Try small case studies (sales report, customer trends)

7️⃣ Create a Portfolio
💻 Share projects on:
– GitHub
– Notion or a simple website
📌 Add visuals + brief explanations of your insights.

8️⃣ Improve Soft Skills
🗣️ Focus on:
– Presenting data in simple words
– Asking good questions
– Thinking critically about patterns

9️⃣ Certifications to Stand Out
🎓 Try:
– Google Data Analytics (Coursera)
– IBM Data Analyst
– LinkedIn Learning basics

🔟 Apply for Internships & Entry Jobs
🎯 Titles to look for:
– Data Analyst (Intern)
– Junior Analyst
– Business Analyst

💬 React ❤️ for more!

✅ How to Build a Job-Ready Data Analytics Portfolio 💼📊

1️⃣ Pick Solid Datasets

• Public: Kaggle, UCI ML Repo, data.gov
• Business-like: e-commerce, churn, marketing spend, HR attrition
• Size: 5k–200k rows, relatively clean

2️⃣ Create 3 Signature Projects

• SQL: Customer Cohort & Retention (joins, window functions)
• BI: Executive Sales Dashboard (Power BI/Tableau, drill-through, DAX/calculated fields)
• Python: Marketing ROI & Attribution (pandas, seaborn, A/B test basics)

3️⃣ Tell a Story, Not Just Charts

• Problem → Approach → Insight → Action
• Add one business recommendation per insight

4️⃣ Document Like a Pro

• README: problem, data source, methods, results, next steps
• Screenshots or GIFs of dashboards
• Repo structure: /data, /notebooks, /sql, /reports

5️⃣ Show Measurable Impact

• “Reduced reporting time by 70% with automated Power BI pipeline”
• “Identified 12% churn segment with a retention playbook”

6️⃣ Make It Easy to Review

• Share live dashboards (Publish to Web), short Loom/YouTube walkthrough
• Include SQL snippets
• Pin top 3 projects on GitHub and LinkedIn Featured

7️⃣ Iterate With Feedback

• Post drafts on LinkedIn, ask “What would you improve?”
• Apply suggestions, track updates in a CHANGELOG
🎯 Goal: 3 projects, 3 stories, 3 measurable outcomes.

💬 Double Tap ❤️ For More!

Core SQL Interview Questions. With answers

1 What is SQL
• SQL stands for Structured Query Language
• You use it to read and manage data in relational databases
• Used in MySQL, PostgreSQL, SQL Server, Oracle

2 What is an RDBMS
• Relational Database Management System
• Stores data in tables with rows and columns
• Uses keys to link tables
• Example. Customer table linked to Orders table using customer_id

3 What is a table
• Structured storage for data
• Rows are records
• Columns are attributes
• Example. One row equals one customer

4 What is a primary key
• Uniquely identifies each row
• Cannot be NULL
• No duplicate values
• Example. user_id in users table

5 What is a foreign key
• Links one table to another
• Refers to a primary key in another table
• Allows duplicate values
• Example. user_id in orders table

6 Difference between primary key and foreign key
• Primary key ensures uniqueness
• Foreign key ensures relationship
• One table can have one primary key
• One table can have multiple foreign keys

7 What is NULL
• Represents missing or unknown value
• Not equal to zero or empty string
• Use IS NULL or IS NOT NULL to check

8 What are constraints
• Rules applied on columns
• Maintain data quality
• Common constraints
– NOT NULL
– UNIQUE
– PRIMARY KEY
– FOREIGN KEY
– CHECK

9 What are data types
• Define type of data stored
• Common types
– INT for numbers
– VARCHAR for text
– DATE for dates
– FLOAT or DECIMAL for decimals

10 Interview tip you must remember
• Always explain with a small example
• Speak logic before syntax
• Keep answers short and direct

Double Tap ❤️ For More