Filter interviews by
Clear (1)
I applied via Recruitment Consulltant and was interviewed in Jul 2024. There were 2 interview rounds.
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]).
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;
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
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
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...
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.
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'
Rate your
company
🤫 100% anonymous
How was your last interview experience?
Asking about ur self introduction and work experience
I applied via Recruitment Consultant and was interviewed before Dec 2019. There were 3 interview rounds.
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 ov...
Top trending discussions
I applied via Company Website and was interviewed in May 2019. There were 5 interview rounds.
I applied via Referral and was interviewed before Apr 2021. There were 3 interview rounds.
Basic sql
The weight of an aircraft is crucial for its performance and safety.
The weight of an aircraft includes the weight of the aircraft itself, fuel, passengers, cargo, and any other equipment on board.
The weight of an aircraft is measured in pounds or kilograms.
The weight of an aircraft affects its takeoff and landing performance, as well as its fuel efficiency and range.
Aircraft manufacturers provide maximum takeoff and la...
I was interviewed before Nov 2019.
SQL query to get top 100 Uber drivers by city
Join drivers and users tables on city
Aggregate driver ratings and count of rides
Order by rating and count of rides
Limit to top 100
Optimizing the listing of Restaurants on Swiggy involves using data-driven strategies to improve visibility, relevance, and user experience.
Analyze user behavior and preferences to understand their needs and preferences
Implement a ranking algorithm based on factors like ratings, reviews, popularity, and delivery time
Optimize search functionality to ensure accurate and relevant results
Collaborate with restaurants to imp...
Linear Regression is used for continuous data while Logistic Regression is used for categorical data.
Linear Regression predicts continuous values while Logistic Regression predicts probabilities.
Linear Regression uses a straight line to fit the data while Logistic Regression uses an S-shaped curve.
Linear Regression uses Mean Squared Error as the cost function while Logistic Regression uses Log Loss.
Linear Regression is...
Bias-Variance trade-off is the balance between overfitting and underfitting. High bias models are simple but inaccurate, low variance models are complex but overfit.
Bias-Variance trade-off is a fundamental concept in machine learning.
High bias models are simple and have low variance, but are inaccurate.
Low bias models are complex and have high variance, but can overfit the data.
Examples of high bias models are linear r...
Possible reasons for a car manufacturer's decline in profits by 40% year over year
Decreased demand for cars due to economic downturn
Increased competition from other car manufacturers
Rising production costs and expenses
Decline in consumer confidence and spending
Changes in government regulations impacting the automotive industry
I applied via Campus Placement and was interviewed in Mar 2021. There was 1 interview round.
This pen is not just a writing instrument, it's a statement of luxury and exclusivity.
Highlight the pen's unique design and craftsmanship
Emphasize the use of high-quality materials
Mention any special features or functions
Create a sense of exclusivity and rarity
Appeal to the buyer's desire for luxury and status
Offer personalized engraving or customization options
Some of the top questions asked at the Swiggy MIS Analyst interview -
based on 2 interviews
Interview experience
Anonymously discuss salaries, work culture, and many more
Get Ambitionbox App
based on 7 reviews
Rating in categories
Delivery Boy
871
salaries
| ₹0 L/yr - ₹0 L/yr |
Fleet Manager
583
salaries
| ₹0 L/yr - ₹0 L/yr |
Sales Manager
523
salaries
| ₹0 L/yr - ₹0 L/yr |
Assistant Manager
498
salaries
| ₹0 L/yr - ₹0 L/yr |
Assistant Store Manager
450
salaries
| ₹0 L/yr - ₹0 L/yr |
Zomato
Dunzo
FoodPanda
Rapido