Delhivery Analyst Interview Questions and Answers

Q1. What is the order of execution for SQL queries?
Ans. 
SQL queries execute in a specific order, determining how data is retrieved and manipulated.
• 1. FROM clause: Specifies the tables to retrieve data from. Example: SELECT * FROM employees.

• 2. JOIN clause: Combines rows from two or more tables based on a related column. Example: SELECT * FROM employees JOIN departments ON employees.dept_id = departments.id.

• 3. WHERE clause: Filters records based on specified conditions. Examp...read more
Answered by AI
Add your answer
Q2. Write SQL query for the question which required knowledge of the LEAD and LAG functions for its solution.
Add your answer
Q3. Puzzle kind of question
Add your answer
Q4. Asked about the past project and discussed about it.
Add your answer

Q1. It majorly based on basic sql and Python with some guesstimates.
Add your answer

It was based on a real life logistics scenario and then solving the case study.

Q1. Asked very basic questions of sql any one who has experience of 1 year should be able to do that
Add your answer