Add office photos
Swiggy logo
Employer?
Claim Account for FREE

Swiggy

3.8
based on 4.1k Reviews
Video summary
Filter interviews by
MIS Analyst
Skills
Clear (1)

Swiggy MIS Analyst Interview Questions and Answers

Updated 23 Aug 2024

Q1. 1.what do you know about Swiggy and it's business model. 2.simple SQL queries 3. Vlookup.

Ans.

Swiggy is an Indian food delivery company that operates through a website and mobile app.

  • Swiggy was founded in 2014 and is headquartered in Bangalore, India.

  • It partners with local restaurants to provide food delivery services to customers.

  • Swiggy's business model is based on charging a commission fee from the restaurants for every order placed through their platform.

  • It has expanded to over 500 cities in India and has over 200,000 restaurant partners.

  • SQL queries are used to ret...read more

Add your answer
right arrow

Q2. 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

Add your answer
right arrow

Q3. 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'

Add your answer
right arrow

Q4. 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]).

Add your answer
right arrow
Discover Swiggy interview dos and don'ts from real experiences

Q5. 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) FROM employees GROUP BY department HAVING AVG(salary) > 5000...read more

Add your answer
right arrow

Q6. 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 columns.

Add your answer
right arrow

Q7. 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.

Add your answer
right arrow

Q8. 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;

Add your answer
right arrow

More about working at Swiggy

Back
Awards Leaf
AmbitionBox Logo
#10 Best Tech Startup - 2022
Awards Leaf
HQ - Bangalore,Karnataka, India
Contribute & help others!
Write a review
Write a review
Share interview
Share interview
Contribute salary
Contribute salary
Add office photos
Add office photos

Interview Process at Swiggy MIS Analyst

based on 2 interviews
Interview experience
3.0
Average
View more
interview tips and stories logo
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories
Recently Viewed
REVIEWS
Amdocs
No Reviews
REVIEWS
Amdocs
No Reviews
INTERVIEWS
Amdocs
No Interviews
SALARIES
Siemens
INTERVIEWS
Swiggy
No Interviews
SALARIES
OPPO
SALARIES
OPPO
SALARIES
Reflexis Systems
SALARIES
OPPO
SALARIES
Haier Appliances India
Share an Interview
Stay ahead in your career. Get AmbitionBox app
play-icon
play-icon
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
75 Lakh+

Reviews

5 Lakh+

Interviews

4 Crore+

Salaries

1 Cr+

Users/Month

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter