i
MASAI School
Filter interviews by
In SQL, data is grouped by a specified column or expression using the GROUP BY clause.
Data is grouped based on the values in the specified column or expression
Aggregate functions like SUM, COUNT, AVG can be used with GROUP BY to perform calculations on each group
GROUP BY is often used in conjunction with the SELECT statement
Example: SELECT department, AVG(salary) FROM employees GROUP BY department
Lists are ordered collections of items, while dictionaries are unordered collections of key-value pairs.
Lists are accessed by index, dictionaries are accessed by key
Lists maintain the order of elements, dictionaries do not guarantee order
Lists use square brackets [], dictionaries use curly braces {}
Example: list - [1, 2, 3], dictionary - {'a': 1, 'b': 2}
Lambda functions are anonymous functions in Python that can have any number of arguments but only one expression.
Lambda functions are defined using the lambda keyword.
They are commonly used for small, one-time tasks.
Lambda functions can take any number of arguments, but can only have one expression.
Example: add = lambda x, y: x + y
I applied via LinkedIn and was interviewed before Oct 2023. There were 2 interview rounds.
Around sql/python and other da tools
Stats and probability with focus on puzzles
Top trending discussions
I applied via Naukri.com and was interviewed in Apr 2023. There were 3 interview rounds.
A general apti round
Data analysis assignment
I applied via Naukri.com and was interviewed before Sep 2021. There were 2 interview rounds.
Question was moderate.based on logical reasoning and math.
Coding test question based on sql and python.
I applied via LinkedIn and was interviewed in Feb 2023. There was 1 interview round.
No, I don't have direct Data Science experience.
However, I have worked with data extensively in my previous roles as a Data Analyst.
I have experience in data cleaning, data visualization, and statistical analysis.
I am also familiar with programming languages such as Python and R, which are commonly used in Data Science.
I am willing to learn and expand my skills in Data Science if given the opportunity.
I applied via Company Website and was interviewed before Mar 2023. There were 3 interview rounds.
Average question where asked
Normal sql based assignment was there
I applied via Naukri.com and was interviewed in Dec 2023. There was 1 interview round.
I applied via Referral and was interviewed in May 2024. There were 5 interview rounds.
Order of execution refers to the sequence in which operations are carried out in a program or system.
Execution starts from the top of the program and moves downwards.
Operations within parentheses are executed first.
Multiplication and division are executed before addition and subtraction.
Functions are executed when they are called.
Control structures like loops and conditionals affect the order of execution.
Use a SQL query to find different routes for an airline based on source and destination columns in a table.
Use a SELECT statement to retrieve the distinct combinations of source and destination.
Use the DISTINCT keyword to ensure only unique routes are returned.
Order the results by source and destination for easier analysis.
based on 2 interviews
Interview experience
based on 1 review
Rating in categories
Operations Manager
40
salaries
| ₹0 L/yr - ₹0 L/yr |
Full Stack Web Developer
29
salaries
| ₹0 L/yr - ₹0 L/yr |
Data Analyst
18
salaries
| ₹0 L/yr - ₹0 L/yr |
Full Stack Developer
17
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Engineer
16
salaries
| ₹0 L/yr - ₹0 L/yr |
upGrad
Simplilearn
Great Learning
Imarticus Learning