Filter interviews by
Clear (1)
My name is John Smith.
My first name is John.
My last name is Smith.
I go by the name John Smith.
I majored in Business Administration with a focus on Operations Management.
Studied courses like Supply Chain Management, Production Planning, and Inventory Control
Participated in case competitions related to optimizing production processes
Completed internships at manufacturing companies to gain hands-on experience
My father's name is John Smith.
His first name is John.
His last name is Smith.
He goes by the name John Smith.
He is known as Mr. Smith in his workplace.
SQL code for having clause
Use the HAVING clause to filter groups based on aggregate functions
It is used with the GROUP BY clause
Example: SELECT department, AVG(salary) FROM employees GROUP BY department HAVING AVG(salary) > 50000;
WHERE is used to filter rows before grouping or aggregating, while HAVING is used to filter groups after grouping or aggregating.
WHERE is used with SELECT, UPDATE, DELETE statements to filter rows based on a condition
HAVING is used with GROUP BY clause to filter groups based on a condition
WHERE is applied before the grouping operation, while HAVING is applied after the grouping operation
Top trending discussions
I applied via Approached by Company and was interviewed before Apr 2022. There were 8 interview rounds.
This is literally a live coding test. For analytics expect SQL, python, R.
Ararat can be sorted alphabetically or numerically.
Sort alphabetically: Arrange in ascending order based on the letters in the word.
Sort numerically: Arrange in ascending order based on the numerical value of each character.
posted on 6 Nov 2019
I applied via Referral and was interviewed before Nov 2018. There were 5 interview rounds.
I applied via Referral and was interviewed in Aug 2024. There was 1 interview round.
Moving Average is a statistical technique used to analyze data points by creating a series of averages of different subsets of the full data set.
Moving Average helps in smoothing out fluctuations in data to identify trends over time.
It is calculated by taking the average of a specific number of data points within a defined window.
For example, a 3-day moving average for stock prices would be the average of the stock pri...
Decorators in Python are functions that modify the behavior of other functions.
Decorators are denoted by the @ symbol followed by the decorator function name.
They allow you to add functionality to an existing function without modifying its code.
Common use cases include logging, timing, and authentication.
Example: @decorator_function def function_to_decorate(): pass
Object Oriented Programming is a programming paradigm based on the concept of objects, which can contain data and code.
OOP focuses on creating objects that interact with each other to solve complex problems.
Objects have attributes (data) and methods (functions) that can manipulate the data.
Encapsulation, inheritance, and polymorphism are key principles of OOP.
Example: In a car simulation program, a 'Car' object can hav...
Classes are blueprints for creating objects in object-oriented programming.
Classes define the properties and behaviors of objects
Objects are instances of classes
Classes can inherit properties and behaviors from other classes
Classes can have constructors to initialize objects
Classes can have methods to perform actions
Functions are blocks of code that perform a specific task and can be reused multiple times in a program.
Functions help in organizing code and making it more modular.
They can take input parameters and return output values.
Functions can be called multiple times from different parts of the program.
Examples: summing two numbers, finding the maximum value in a list.
Swap L1 and L5 in a list
Create a temporary variable to store the value of L1
Assign the value of L5 to L1
Assign the value of the temporary variable to L5
I applied via Campus Placement
I applied via Campus Placement
I applied via LinkedIn and was interviewed in Sep 2020. There was 1 interview round.
Sharing data insights can help improve services and identify revenue opportunities.
Analyzing customer behavior can help identify areas for improvement
Identifying trends in sales data can help optimize pricing strategies
Using data to personalize marketing efforts can increase customer engagement
Predictive modeling can help identify potential revenue opportunities
Tracking key performance indicators can help optimize busi
I applied via Naukri.com and was interviewed in May 2021. There was 1 interview round.
Extract 'oyo' from domain name in Google Sheets.
Use the formula =REGEXEXTRACT(A1, "oyo") where A1 is the cell containing the domain name.
This will extract the first occurrence of 'oyo' in the domain name.
If 'oyo' appears multiple times, use =REGEXEXTRACT(A1, "oyo", 2) for the second occurrence, and so on.
Time() is a SQL function that returns the current system date and time.
Time() can be used in SELECT, INSERT, UPDATE, and DELETE statements.
The returned value is in the format 'YYYY-MM-DD HH:MI:SS'.
Timezone can affect the returned value.
Example: SELECT Time() AS CurrentTime;
based on 1 interview
Interview experience
Senior Travel Consultant
226
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Executive
219
salaries
| ₹0 L/yr - ₹0 L/yr |
Travel Consultant
115
salaries
| ₹0 L/yr - ₹0 L/yr |
Assistant Manager
111
salaries
| ₹0 L/yr - ₹0 L/yr |
Team Lead
91
salaries
| ₹0 L/yr - ₹0 L/yr |
MakeMyTrip
Cleartrip
Goibibo
Oyo Rooms