PharmEasy interview experience Real time questions & tips from candidates to crack your interview
Data Analyst
PharmEasy
1 rounds | 1 Coding
problems
Rejected
Interview preparation journey
Journey
My interview preparation was a great learning experience. I focused on practicing SQL queries, data analysis problems, and revising key concepts. Regular practice, working on projects, and taking mock interviews helped me strengthen my skills, improve problem-solving, and gain confidence to perform well in the actual interviews.
Preparation
Topics: SQL
Application process
Where: Coding Ninjas Placement Cell
Eligibility: Any graduate
Interview rounds
01
Round
Easy
Online Coding Interview
Duration
Interview date19 Sep 2025
Coding problem1
1. SQL Query
The interviewer asked me to explain the difference between HAVING and WHERE clauses. I was also asked to show the output for LEFT JOIN and INNER JOIN, and solve three queries based on aggregation — one involving a subquery in the HAVING clause and another with WHERE conditions on multiple criteria.
Problem approach
- First Query: I analyzed the table and applied GROUP BY along with a HAVING condition to filter the aggregated results.
- Second Query: I joined two tables using an INNER JOIN and incorporated a subquery in the HAVING clause to filter the grouped data.
- Third Query: I used a WHERE clause with the AND operator to filter data based on multiple criteria.
Here's your problem of the day 
Solving this problem will increase your chance to get selected in this company
Skill covered: Programming
What is recursion?
Choose another skill to practice
Similar interview experiences
Frontend Developer
4 rounds | 4 problems
Interviewed by PharmEasy
Selected 
1801 views
0 comments
0 upvotes
Software Engineer
5 rounds | 4 problems
Interviewed by PharmEasy
Selected 1377 views
0 comments
0 upvotes
Technical Lead
3 rounds | 4 problems
Interviewed by PharmEasy
Rejected
0 views
0 comments
0 upvotes
Data Analyst
1 rounds | 2 problems
Interviewed by PharmEasy
Rejected
194 views
0 comments
0 upvotes