Swiggy Interview Questions, Process, and Tips

Q1. Rank Function Application in Google Sheet?
Ans. 
Rank function in Google Sheets is used to assign a rank to a value in a list based on its order.
• Rank function is used to determine the rank of a value in a list.

• It can be used to rank values in ascending or descending order.

• The syntax for the rank function is RANK(value, range, [is_ascending]).
Answered by AI
Add your answer
Q2. Joins From SQL?
Ans. 
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
• Joins are used to retrieve data from multiple tables based on a related column.

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;
Answered by AI
Add your answer
Q3. Order Of query execution in SQL?
Ans. 
The order of query execution in SQL is: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.
• FROM: Specifies the tables from which data will be retrieved.

• WHERE: Filters the rows based on specified conditions.

• GROUP BY: Groups the rows based on specified columns.

• HAVING: Filters the groups based on specified conditions.

• SELECT: Retrieves the columns specified in the query.

• ORDER BY: Sorts the result set based on specified column
Answered by AI
Add your answer
Q4. Write a query to find out students has greater than 80 marks and from English subject?
Ans. 
Query to find students with over 80 marks in English subject
• Use SELECT statement to retrieve data

• Filter the results using WHERE clause for marks greater than 80

• Include condition for English subject using AND operator
Answered by AI
Add your answer

Q1. When we use having clause ?
Ans. 
HAVING clause is used in SQL to filter groups based on specified conditions after GROUP BY clause.
• HAVING clause is used with GROUP BY clause to filter groups based on specified conditions.

• It is used to filter the results of aggregate functions like COUNT, SUM, AVG, etc.

• It is used to apply conditions to groups, similar to WHERE clause which applies conditions to individual rows.

• Example: SELECT department, AVG(salary) FR...read more
Answered by AI
Add your answer
Q2. Aggregate Function Application?
Ans. 
Aggregate functions are used to perform calculations on groups of rows in a table.
• Aggregate functions include SUM, AVG, COUNT, MIN, and MAX.

• They are commonly used in SQL queries to summarize data.

• For example, you can use SUM to calculate the total sales for a specific product.

• Another example is using AVG to find the average salary of employees in a department.
Answered by AI
Add your answer
Q3. Group by and order By?
Add your answer
Q4. Write a query employes join between such dates?
Ans. 
Use a SQL query with JOIN to retrieve employees between specified dates.
• Use the JOIN keyword to combine data from two tables

• Specify the date range using the WHERE clause

• Example: SELECT * FROM employees e JOIN dates d ON e.date = d.date WHERE d.date BETWEEN '2022-01-01' AND '2022-12-31'
Answered by AI
Add your answer

Q1. Tell me about yourself and workex, One campaign you are proud of and what you did, The interview lasted for 30 mins.
Add your answer
Q2. Why are you leaving your current company and details on that.
Ans. 
Seeking new challenges and opportunities for growth.
• Desire for new challenges and opportunities for growth

• Looking for a company with better work-life balance

• Seeking a role with more responsibility and leadership opportunities
Answered by AI
Add your answer

Q1. Tell me about yourself, 2 digital campaigns that you did and what you learn from them, Logical question on bulb : 3 bulbs are in a room and it's switches are outside the room, and you can only enter the ro...read more
Add your answer
Q2. How many times does whatsapp application gets open in your household?
Ans. 
WhatsApp is opened multiple times daily in my household for communication and sharing updates.
• WhatsApp is opened multiple times daily for communication with family and friends

• Used for sharing updates, photos, and videos

• Helps in coordinating plans and staying connected with loved ones
Answered by AI
Add your answer

Q1. The interviewer can ask additional questions to better understand responses
Add your answer

Q1. This interview can ask questions to better understand responses
Add your answer

Q1. This interview can ask questions to better understand responses
Add your answer

Q1. This interview can ask questions to better understand responses
Add your answer

Q1. This interview can ask questions to better understand responses
Add your answer

Study how to onboard a restaurant on Swiggy while preparing for the test.

Q1. Work Experience you want join, can you use swiggy,what is improvement in swiggy app
Ans. 
Yes, I can use Swiggy. The improvement in Swiggy app includes faster delivery, better user interface, and more restaurant options.
• Faster delivery times through optimization of delivery routes

• Improved user interface for easier navigation and ordering

• Increased restaurant options for a wider variety of cuisines

• Enhanced tracking features for real-time updates on order status
Answered by AI
Add your answer
Q2. What is your future goal?
Ans. 
My future goal is to become a successful sales manager by consistently exceeding targets and building strong relationships with clients.
• Advance to a sales manager position within the next 5 years

• Consistently exceed sales targets and KPIs

• Build and maintain strong relationships with clients to ensure repeat business

• Continuously improve sales skills through training and development programs
Answered by AI
Add your answer
Q3. What you think improvement in swiggy app ?
Ans. 
Improvements in Swiggy app can include faster delivery times, improved user interface, personalized recommendations, and better customer support.
• Faster delivery times to enhance customer satisfaction

• Improved user interface for easier navigation and ordering

• Personalized recommendations based on user preferences and past orders

• Better customer support for resolving issues quickly and efficiently
Answered by AI
Add your answer
Q4. Are you suitable for this job profile?
Ans. 
Yes, I am suitable for this job profile due to my strong communication skills, ability to build relationships, and passion for sales.
• Strong communication skills

• Ability to build relationships

• Passion for sales
Answered by AI
Add your answer
Q5. You have a bike?
Ans. 
Yes, I have a bike. It's a red mountain bike with 21 gears.
• Yes, I have a red mountain bike

• It has 21 gears

• I use it for commuting to work and leisure rides
Answered by AI
Add your answer