🧠 Real-World SQL Practice Questions with Solutions

1. Find duplicate email addresses in the Users table

SELECT email, COUNT(*) AS count  
FROM Users  
GROUP BY email  
HAVING COUNT(*) > 1;

2. Retrieve the highest-paid employee per department

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

3. Count the number of orders each customer placed

SELECT c.name, COUNT(o.id) AS total_orders  
FROM Customers c  
LEFT JOIN Orders o ON c.id = o.customer_id  
GROUP BY c.name;

4. Find products never sold

SELECT p.name  
FROM Products p  
LEFT JOIN Sales s ON p.id = s.product_id  
WHERE s.product_id IS NULL;

5. Get the most recent 5 orders

SELECT * FROM Orders  
ORDER BY order_date DESC  
LIMIT 5;

6. Find employees earning above average salary

SELECT * FROM Employees  
WHERE salary > (SELECT AVG(salary) FROM Employees);

7. Get monthly sales totals

SELECT  
  DATE_FORMAT(sale_date, '%Y-%m') AS month,  
  SUM(amount) AS total  
FROM Sales  
GROUP BY month;

8. Show customers who ordered ‘Laptop’ more than once

SELECT customer_id, COUNT(*) AS count  
FROM Orders  
WHERE product = 'Laptop'  
GROUP BY customer_id  
HAVING COUNT(*) > 1;

💬 Tap ❤️ if this helped you!

NTT DATA
Position: Business Analyst, Data & Analytics
Qualification: Bachelor's Degree
Experience: Freshers/ Experienced
Location: Bangalore, India

📌Apply Now: https://careers.services.global.ntt/global/en/job/R-136424/Business-Intelligence-Analyst

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

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

All the best! 👍👍

Siemens is hiring
Position: Data Analyst
Qualifications: Bachelor's Degree
Experience: Freshers/ Experienced
Location: Bangalore; Pune, India

📌Apply Link: https://jobs.siemens.com/en_US/externaljobs/JobDetail/478949

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

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

All the best! 👍👍

bluCognition is hiring Analytics Intern 🚀

Experience : Freshers
Location : Remote

Apply link : https://www.linkedin.com/jobs/view/4315664200

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

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

All the best! 👍👍

Slice is hiring Business Analyst 🚀

Experience : 1-2 Year
Location : Bangalore

Apply link : https://www.linkedin.com/jobs/view/4315665693

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

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

All the best! 👍👍

𝐎𝐫𝐚𝐜𝐥𝐞 𝐢𝐬 𝐡𝐢𝐫𝐢𝐧𝐠 𝐈𝐧𝐭𝐞𝐫𝐧𝐬𝐡𝐢𝐩𝐬!
Position: Student Intern
Qualifications: Bachelor’s/ Master’s Degree
Experience: Freshers
Location: Bangalore; Hyderabad; New Delhi, India

📌Apply Link: https://careers.oracle.com/en/sites/jobsearch/jobs/preview/311467/?keyword=Student+%2F+Intern&location=India&locationId=300000000106947

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

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

All the best! 👍👍

Meesho
Position: Business Analyst, Analytics
Qualification: Bachelor’s/ Master’s/ MBA
Experience: 1+ (Years)
Location: Bangalore, India

📌Apply Now: https://www.meesho.io/jobs/business-analyst-ii?id=89fea73b-26f2-444d-83aa-80096e44c0c5

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

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

All the best! 👍👍

American Express
Position: Analyst - Data Science
Qualifications: Bachelor’s/ Master’s Degree/ MBA
Experience: Freshers (0 to 2 Years)
Location: Bengaluru; Gurgaon, India (Hybrid)

📌Apply Now: https://aexp.eightfold.ai/careers/job/38504987?hl=en

All the best 👍👍

JPMorgan
Position: Data Analyst
Qualification: Bachelor’s/ Master’s Degree
Experience: Freshers/ Experienced
Location: Hyderabad/ Bangalore

📌Apply Now: https://jpmc.fa.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_1001/jobs/preview/210674206/?keyword=Client+Data+Analyst&mode=location

https://jpmc.fa.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_1001/job/210673758?keyword=Client+Data+Analyst&mode=location

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

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

All the best! 👍👍

Amazon
Position: Business Analyst
Qualifications: Bachelor’s/ Master’s Degree
Experience: Freshers/ Experienced
Location: Bangalore, India

📌Apply Now: https://www.amazon.jobs/en/jobs/3010621/business-analyst-ihs-and-flex

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

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

All the best 👍👍

𝐂𝐚𝐩𝐠𝐞𝐦𝐢𝐧𝐢
Position: Power BI Developer
Qualifications: Bachelor’s/ Master’s Degree
Experience: Freshers/ Experienced
Location: Bangalore, India

📌Apply Link: https://www.capgemini.com/in-en/jobs/166904-en_GB+sap_btp

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

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

All the best 👍👍

Qualcomm
Position: Finance Associate
Qualification: Bachelor's Degree/ B.Com/ BBA/ MBA
Experience: Freshers/ Experienced
Location: Bangalore, India

📌Apply Link: https://careers.qualcomm.com/careers/job/446715077824

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

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

All the best 👍👍

Razorpay
Position: Junior Associate - Emerging Business
Qualifications: Bachelor's/ Master's Degree
Experience: Freshers/ Experienced
Location: Bangalore, India

📌Apply Link: https://razorpay.com/jobs/jobs-all/detail/?gh_jid=4615980005

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

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

All the best 👍👍

Unilever
Position: Data Analyst
Qualification: Bachelor’s/ Master’s Degree
Experience: Freshers/ Experienced
Location: India

📌Apply Now: https://careers.unilever.com/job/bengaluru/data-analyst/34155/84777193040

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

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

All the best 👍👍

Power BI Developer 
Role: Power BI Developer 
Skills :  Power BI+SQL
Notice : immediate to 10 days
Location-Bangalore,Pune, Gurugram
Exp- 4-7 year
If anyone interested send me your updated CV
madhuric@huquo.com
cc : career@huquo.com

PwC is hiring
Position: Business Analyst - Associate
Qualification: Bachelor’s/ Master's degree
Experience: Freshers/ Experienced
Location: Bangalore, India

📌Apply Now: https://jobs-ta.pwc.com/global/en/job/652848WD/BCSO-Business-Analyst-Associate

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

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

All the best 👍👍

Goldman Sachs
Position: Analyst - Data Analytics
Qualification: Bachelor’s/ Master’s/ MBA
Experience: Freshers/ Experienced
Location: Bengaluru, India

📌Apply Now: https://higher.gs.com/roles/151492

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

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

All the best 👍👍

Power BI Developer
We're looking for a skilled Power BI Developer to join our team and help transform data into insightful visual reports and dashboards.
🔧 Key Responsibilities:
Develop and deploy Power BI reports and dashboards
Create data models and implement row-level security
Integrate Power BI with applications using embedded analytics
Optimize datasets and perform advanced DAX calculations
Work with data engineers to ensure data quality and performance
🎯 Requirements:
5+ years of Power BI experience (DAX, Power Query, SQL)
Strong knowledge of data modeling and warehousing
Experience with Microsoft BI stack (SSIS, SSRS, SSAS)
Bachelor’s degree in Computer Science or related field
Python or R knowledge is a plus
📍 Location: Pune
📧 Apply Now: Pallavi.kaushal@mwidm.com

Paytm
Position: Business Analyst, Analytics
Qualifications: Bachelor’s/ Master’s Degree
Experience: Freshers/ Experienced
Location: Bangalore; Noida, India

📌Apply Now: https://jobs.lever.co/paytm/8396fef1-c6d8-4356-bbd4-a81ad64cc08a

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

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

All the best 👍👍

Wipro is hiring
Position: Associate Analyst
Qualification: Bachelor’s/ Master’s degree
Experience: 0-2 (Years)
Location: Mumbai, India

📌Apply Now: https://careers.wipro.com/job/Associate-Analyst/96623-en_US

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

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

All the best 👍👍

Seeking a seasoned expert for Senior Data Scientist/lead scorecard development using Indian bureau data (CIBIL, CRIF, Experian).

🔹 Location: Mumbai
🔹 Experience: 4 - 12 years
🔹 Tech Stack: Python | SQL
🔹 Domain: Application & Behavioral Scorecards
🔹 Bureau Exposure: CIBIL / CRIF / Experian
🔹 Role: Strategic model building + hands-on deployment

If you’ve built robust risk models and enjoy translating bureau insights into scalable decision systems, this opportunity might be your next big move.

please share your updated resume at parnika.nirwal@sdnaglobal.com