PharmEasy interview experience Real time questions & tips from candidates to crack your interview
Data Analyst
PharmEasy
1 rounds | 2 Coding
problems
Rejected
Interview preparation journey
Journey
I prepared by practicing basic SQL queries regularly and thoroughly revising the PDF materials provided in the curriculum, which helped me strengthen my concepts and gain confidence for the interview.
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 problem2
1. SQL Query
During the interview, I was asked to explain the difference between COUNT(*) and COUNT(column). I was also given questions to practically demonstrate different types of JOINs and explain how I would use CASE statements in SQL to handle conditional logic.
2. SQL Query
The interviewer asked me to explain the concept of UNION in SQL and write queries using the SUM() function. I was also given questions on constraints, such as retrieving all records where names start with a specific letter (e.g., 'L').
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 the purpose of the return keyword?
Choose another skill to practice
Similar interview experiences
SDE - 1
2 rounds | 4 problems
Interviewed by PharmEasy
Rejected
1012 views
0 comments
0 upvotes
SDE - 1
2 rounds | 4 problems
Interviewed by PharmEasy
Rejected
1110 views
0 comments
0 upvotes
Software Engineer
3 rounds | 6 problems
Interviewed by PharmEasy
Rejected
338 views
0 comments
0 upvotes
Data Analyst
1 rounds | 1 problems
Interviewed by PharmEasy
Rejected
186 views
0 comments
0 upvotes