5⃣ frequently Asked SQL Interview Questions with Answers in data analyst interviews

📍1. Write a SQL query to find the average purchase amount for each customer. Assume you have two tables: Customers (CustomerID, Name) and Orders (OrderID, CustomerID, Amount).

SELECT c.CustomerID, c. Name, AVG(o.Amount) AS AveragePurchase
FROM Customers c
JOIN Orders o ON c.CustomerID = o.CustomerID
GROUP BY c.CustomerID, c. Name;

📍2. Write a query to find the employee with the minimum salary in each department from a table Employees with columns EmployeeID, Name, DepartmentID, and Salary.

SELECT e1.DepartmentID, e1.EmployeeID, e1 .Name, e1.Salary
FROM Employees e1
WHERE Salary = (SELECT MIN(Salary) FROM Employees e2 WHERE e2.DepartmentID = e1.DepartmentID);

📍3. Write a SQL query to find all products that have never been sold. Assume you have a table Products (ProductID, ProductName) and a table Sales (SaleID, ProductID, Quantity).

SELECT p.ProductID, p.ProductName
FROM Products p
LEFT JOIN Sales s ON p.ProductID = s.ProductID
WHERE s.ProductID IS NULL;

📍4. Given a table Orders with columns OrderID, CustomerID, OrderDate, and a table OrderItems with columns OrderID, ItemID, Quantity, write a query to find the customer with the highest total order quantity.

SELECT o.CustomerID, SUM(oi.Quantity) AS TotalQuantity
FROM Orders o
JOIN OrderItems oi ON o.OrderID = oi.OrderID
GROUP BY o.CustomerID
ORDER BY TotalQuantity DESC
LIMIT 1

;

📍5. Write a SQL query to find the earliest order date for each customer from a table Orders (OrderID, CustomerID, OrderDate).

SELECT CustomerID, MIN(OrderDate) AS EarliestOrderDate
FROM Orders
GROUP BY CustomerID

Hope it helps :)

𝟱 𝗙𝗿𝗲𝗲 𝗚𝗼𝗼𝗴𝗹𝗲 𝗔𝗜 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝘁𝗼 𝗞𝗶𝗰𝗸𝘀𝘁𝗮𝗿𝘁 𝗬𝗼𝘂𝗿 𝗔𝗿𝘁𝗶𝗳𝗶𝗰𝗶𝗮𝗹 𝗜𝗻𝘁𝗲𝗹𝗹𝗶𝗴𝗲𝗻𝗰𝗲 𝗖𝗮𝗿𝗲𝗲𝗿😍

🎓 You don’t need to break the bank to break into AI!🪩

If you’ve been searching for beginner-friendly, certified AI learning—Google Cloud has you covered🤝👨‍💻

𝐋𝐢𝐧𝐤👇:-

https://pdlink.in/3SZQRIU

📍All taught by industry-leading instructors✅️

𝗧𝗼𝗽 𝟱 𝗙𝗿𝗲𝗲 𝗞𝗮𝗴𝗴𝗹𝗲 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝘄𝗶𝘁𝗵 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻𝘀 𝘁𝗼 𝗝𝘂𝗺𝗽𝘀𝘁𝗮𝗿𝘁 𝗬𝗼𝘂𝗿 𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲 𝗖𝗮𝗿𝗲𝗲𝗿😍

Want to break into Data Science but not sure where to start?🚀

These free Kaggle micro-courses are the perfect launchpad — beginner-friendly, self-paced, and yes, they come with certifications!👨‍🎓🎊

𝐋𝐢𝐧𝐤👇:-

https://pdlink.in/4l164FN

No subscription. No hidden fees. Just pure learning from a trusted platform✅️

𝟱 𝗙𝗿𝗲𝗲 𝗠𝗶𝗰𝗿𝗼𝘀𝗼𝗳𝘁 + 𝗟𝗶𝗻𝗸𝗲𝗱𝗜𝗻 𝗖𝗮𝗿𝗲𝗲𝗿 𝗘𝘀𝘀𝗲𝗻𝘁𝗶𝗮𝗹 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻𝘀 𝘁𝗼 𝗕𝗼𝗼𝘀𝘁 𝗬𝗼𝘂𝗿 𝗥𝗲𝘀𝘂𝗺𝗲😍

Ready to upgrade your career without spending a dime?✨️

From Generative AI to Project Management, get trained by global tech leaders and earn certificates that carry real value on your resume and LinkedIn profile!📲📌

𝐋𝐢𝐧𝐤👇:-

https://pdlink.in/469RCGK

Designed to equip you with in-demand skills and industry-recognised certifications📜✅️

🔰 C++ Roadmap for Beginners 2025
├── 🧠 Introduction to C++ & How It Works
├── 🧰 Setting Up Environment (IDE, Compiler)
├── 📝 Basic Syntax & Structure
├── 🔢 Variables, Data Types & Constants
├── ➕ Operators (Arithmetic, Relational, Logical, Bitwise)
├── 🔁 Flow Control (if, else, switch)
├── 🔄 Loops (for, while, do...while)
├── 🧩 Functions (Declaration, Definition, Recursion)
├── 📦 Arrays, Strings & Vectors
├── 🧱 Pointers & References
├── 🧮 Dynamic Memory Allocation (new, delete)
├── 🏗 Structures & Unions
├── 🏛 Object-Oriented Programming (Classes, Objects, Inheritance, Polymorphism)
├── 📂 File Handling in C++
├── ⚠️ Exception Handling
├── 🧠 STL (Standard Template Library - vector, map, set, etc.)
├── 🧪 Mini Projects (Bank System, Student Record, etc.)

Like for the detailed explanation ❤️

#c #programming

𝟰 𝗙𝗥𝗘𝗘 𝗛𝗮𝗿𝘃𝗮𝗿𝗱 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝗳𝗼𝗿 𝗕𝗲𝗴𝗶𝗻𝗻𝗲𝗿𝘀 𝗶𝗻 𝗧𝗲𝗰𝗵 (𝗡𝗼 𝗘𝘅𝗽𝗲𝗿𝗶𝗲𝗻𝗰𝗲 𝗡𝗲𝗲𝗱𝗲𝗱!)😍

Dreaming of learning from Harvard — without spending a rupee?💰

You’re in luck! These 4 beginner-friendly courses from Harvard University are completely free, self-paced, & beginner-approved👨‍🎓📌

𝐋𝐢𝐧𝐤👇:-

https://pdlink.in/44pDCYd

Taught by world-class professors!✅️

We're Hiring: Data Scientist at RBL Bank!

Are you passionate about turning data into insights and impact? We're on the lookout for a Data Scientist who brings hands-on experience in Python, SQL, and Tableau to join our dynamic and fast-growing analytics team.

What You’ll Be Doing:

Translating complex business problems into data-driven solutions
Creating insightful dashboards, reports, and machine learning models
Collaborating closely with cross-functional teams to enable smarter decisions
What We’re Looking For:

Proficiency in Python (Pandas, scikit-learn, etc.)
Strong command over SQL for data extraction and transformation
Experience with Tableau or any other BI tools for visual storytelling
If this sounds like you — or someone you know — feel free to DM or send your resume to amit.singh8@rblbank.com.

𝐄𝐱𝐜𝐢𝐭𝐢𝐧𝐠 𝐎𝐩𝐩𝐨𝐫𝐭𝐮𝐧𝐢𝐭𝐲 𝐚𝐭 𝐀𝐞𝐫𝐞𝐨 – 𝐖𝐞’𝐫𝐞 𝐇𝐢𝐫𝐢𝐧𝐠 𝐚 𝐃𝐚𝐭𝐚 𝐒𝐜𝐢𝐞𝐧𝐜𝐞 𝐈𝐧𝐭𝐞𝐫𝐧! 🚀

Are you looking for a hands-on learning experience in 𝐀𝐈/𝐌𝐋, 𝟐𝐃 / 𝟑𝐃 𝐂𝐨𝐦𝐩𝐮𝐭𝐞𝐫 𝐯𝐢𝐬𝐢𝐨𝐧, 𝐚𝐧𝐝 𝐆𝐞𝐧𝐞𝐫𝐚𝐭𝐢𝐯𝐞 𝐀𝐈?

We’re expanding our team and seeking Data Science Interns. If you’re passionate about 𝐥𝐞𝐯𝐞𝐫𝐚𝐠𝐢𝐧𝐠 𝐀𝐈 𝐭𝐨 𝐫𝐞𝐯𝐨𝐥𝐮𝐭𝐢𝐨𝐧𝐢𝐳𝐞 𝐝𝐫𝐨𝐧𝐞𝐬, 𝐦𝐚𝐩𝐩𝐢𝐧𝐠, 𝐬𝐮𝐫𝐯𝐞𝐲𝐢𝐧𝐠, 𝐦𝐢𝐧𝐢𝐧𝐠, 𝐚𝐧𝐝 𝐢𝐧𝐟𝐫𝐚𝐬𝐭𝐫𝐮𝐜𝐭𝐮𝐫𝐞 𝐚𝐩𝐩𝐥𝐢𝐜𝐚𝐭𝐢𝐨𝐧𝐬—and you have strong skills in Python, Deep learning, and Computer Vision—let’s connect.
https://aus.keka.com/careers/jobdetails/86596

𝟱 𝗙𝗥𝗘𝗘 𝗣𝘆𝘁𝗵𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝗳𝗼𝗿 𝗕𝗲𝗴𝗶𝗻𝗻𝗲𝗿𝘀 𝗯𝘆 𝗛𝗮𝗿𝘃𝗮𝗿𝗱, 𝗜𝗕𝗠, 𝗨𝗱𝗮𝗰𝗶𝘁𝘆 & 𝗠𝗼𝗿𝗲😍

Looking to learn Python from scratch—without spending a rupee? 💻

Offered by trusted platforms like Harvard University, IBM, Udacity, freeCodeCamp, and OpenClassrooms, each course is self-paced, easy to follow, and includes a certificate of completion🔥👨‍🎓

𝐋𝐢𝐧𝐤👇:-

https://pdlink.in/3HNeyBQ

Kickstart your career✅️

American Express is hiring Analyst 🚀

Qualification : Post Graduation
Experience : 0-2 Years
Location : Bangalore / Gurugram

Apply link : https://aexp.eightfold.ai/careers/job/29724854?hl=en&utm_source=linkedin&domain=aexp.com

👉 WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

𝟭𝟬 𝗥𝗲𝗮𝗹 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄 𝗤𝘂𝗲𝘀𝘁𝗶𝗼𝗻𝘀 & 𝗛𝗼𝘄 𝘁𝗼 𝗔𝗻𝘀𝘄𝗲𝗿 𝗧𝗵𝗲𝗺 𝗟𝗶𝗸𝗲 𝗮 𝗣𝗿𝗼😍

💼 Data Analytics interviews can feel overwhelming ✨️

You’re expected to know SQL, Python, Excel, Power BI, and be ready with real-world logic👨‍💻📌

𝐋𝐢𝐧𝐤👇:-

https://pdlink.in/3HSnvtq

Enjoy Learning ✅️

List of Top 12 Coding Channels on WhatsApp:

1. Python Programming:
https://whatsapp.com/channel/0029VaiM08SDuMRaGKd9Wv0L


2. Coding Resources:
https://whatsapp.com/channel/0029VahiFZQ4o7qN54LTzB17


3. Coding Projects:
https://whatsapp.com/channel/0029VazkxJ62UPB7OQhBE502


4. Coding Interviews:
https://whatsapp.com/channel/0029VammZijATRSlLxywEC3X


5. Java Programming:
https://whatsapp.com/channel/0029VamdH5mHAdNMHMSBwg1s


6. Javascript:
https://whatsapp.com/channel/0029VavR9OxLtOjJTXrZNi32


7. Web Development:
https://whatsapp.com/channel/0029VaiSdWu4NVis9yNEE72z


8. Artificial Intelligence:
https://whatsapp.com/channel/0029VaoePz73bbV94yTh6V2E


9. Data Science:
https://whatsapp.com/channel/0029Va4QUHa6rsQjhITHK82y


10. Machine Learning:
https://whatsapp.com/channel/0029Va8v3eo1NCrQfGMseL2D


11. SQL:
https://whatsapp.com/channel/0029VanC5rODzgT6TiTGoa1v


12. GitHub:
https://whatsapp.com/channel/0029Vawixh9IXnlk7VfY6w43

ENJOY LEARNING 👍👍

𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴 𝗦𝗤𝗟 𝗖𝗮𝗻 𝗕𝗲 𝗙𝘂𝗻! 𝟰 𝗜𝗻𝘁𝗲𝗿𝗮𝗰𝘁𝗶𝘃𝗲 𝗣𝗹𝗮𝘁𝗳𝗼𝗿𝗺𝘀 𝗧𝗵𝗮𝘁 𝗙𝗲𝗲𝗹 𝗟𝗶𝗸𝗲 𝗮 𝗚𝗮𝗺𝗲😍

Think SQL is all about dry syntax and boring tutorials? Think again.🤔

These 4 gamified SQL websites turn learning into an adventure — from solving murder mysteries to exploring virtual islands, you’ll write real SQL queries while cracking clues and completing missions📊📌

𝐋𝐢𝐧𝐤👇:-

https://pdlink.in/4nh6PMv

These platforms make SQL interactive, practical, and fun✅️

1. What are the ways to detect outliers?

Outliers are detected using two methods:

Box Plot Method: According to this method, the value is considered an outlier if it exceeds or falls below 1.5*IQR (interquartile range), that is, if it lies above the top quartile (Q3) or below the bottom quartile (Q1).

Standard Deviation Method: According to this method, an outlier is defined as a value that is greater or lower than the mean ± (3*standard deviation).


2. What is a Recursive Stored Procedure?

A stored procedure that calls itself until a boundary condition is reached, is called a recursive stored procedure. This recursive function helps the programmers to deploy the same set of code several times as and when required.


3. What is the shortcut to add a filter to a table in EXCEL?

The filter mechanism is used when you want to display only specific data from the entire dataset. By doing so, there is no change being made to the data. The shortcut to add a filter to a table is Ctrl+Shift+L.

4. What is DAX in Power BI?

DAX stands for Data Analysis Expressions. It's a collection of functions, operators, and constants used in formulas to calculate and return values. In other words, it helps you create new info from data you already have.