Licious Data Analyst Interview Questions and Answers

Q1. Find 3rd highest salary using SQL
Ans. 
Use SQL query with ORDER BY and LIMIT to find 3rd highest salary.
• Use SELECT statement to retrieve salary column

• Use ORDER BY clause to sort salaries in descending order

• Use LIMIT 2,1 to skip first two highest salaries and retrieve the third highest salary
Answered by AI
Add your answer
Q2. Queries on self join
Add your answer

Q1. Questions on Power B, DAX etc.,
Add your answer

Round duration - 60 minutes
Round difficulty - Easy

Prepare well for SQL, you have to be strong in SQL. Questions related to SQL and A/B testing were asked.

Q1. Can you write a query to calculate the rolling sum?
Ans. 
Query to calculate rolling sum
• Use window functions like SUM() OVER() in SQL

• Specify the window frame to define the range for the rolling sum

• Example: SELECT date, value, SUM(value) OVER (ORDER BY date ROWS BETWEEN 2 PRECEDING AND CURRENT ROW) AS rolling_sum FROM table_name
Answered by AI
Add your answer

Q1. Types of Joins in SQL, minimum and maximum number of rows possible from these joins
Ans. 
Types of SQL joins and their minimum and maximum possible rows.
• Types of joins: Inner, Left Outer, Right Outer, Full Outer, Cross

• Minimum rows: Inner - 0, Left/Right Outer - 1, Full Outer - 0, Cross - product of rows

• Maximum rows: Inner/Left/Right/Full Outer - product of rows, Cross - product of rows
Answered by AI
Add your answer
Q2. Mean, median, mode, measures of central tendency
Add your answer

1.Features you would look for if you have to buy an elevator
2. How do you estimate the number of trains passing through a station

Q1. Why do you want to join swiggy ? What are your plans for upcoming years ?
Add your answer

Q1. What are your salary expectations?
Add your answer

SQL and case study and was of an hour length

Q1. Mostly SQL based questions
Add your answer

Q1. Statistics and data Visualization and SQL again
Add your answer

Q1. Job fit and more sql
Add your answer

SQL And Excel Test with Intermidiate to Entry level questions

SQL Test with questions on Window fx and logic

Case on various company and there problems

Q1. Why revenue of Flipkart dropped 20% in December, Compared to November.
Ans. 
The drop in Flipkart's revenue in December compared to November can be attributed to seasonal factors, promotional activities, or changes in consumer behavior.
• Seasonal factors such as holiday sales in November leading to higher revenue compared to December

• Promotional activities like Black Friday or Cyber Monday driving higher sales in November

• Changes in consumer behavior, such as delayed purchases or reduced spending a
Answered by AI
Add your answer
Q2. Why you want to join Swiggy
Ans. 
I want to join Swiggy because of its innovative technology, fast-paced environment, and impact on the food delivery industry.
• Swiggy's cutting-edge technology and data-driven approach to food delivery excites me

• I am drawn to the fast-paced and dynamic work environment at Swiggy

• Swiggy's significant impact on the food delivery industry and its rapid growth potential are appealing to me
Answered by AI
Add your answer