Filter interviews by
I applied via Approached by Company and was interviewed before Mar 2023. There were 2 interview rounds.
Logical Reasoning Puzzles, Guesstimates, Game Features
Calculating LTV involves determining the average revenue a customer will generate over their lifetime with the company.
Calculate average revenue per customer per month
Determine average customer lifespan
Multiply average revenue per customer per month by average customer lifespan to get LTV
Top trending discussions
Different question were asked on sql python java
posted on 13 Jun 2022
I applied via Recruitment Consulltant and was interviewed in May 2022. There were 3 interview rounds.
posted on 25 Oct 2023
posted on 21 Feb 2024
posted on 29 Jul 2024
posted on 10 Aug 2024
I applied via Naukri.com and was interviewed in Jul 2024. There was 1 interview round.
Union combines and removes duplicates, Union All combines without removing duplicates
Union combines result sets and removes duplicates
Union All combines result sets without removing duplicates
Union is slower than Union All as it involves removing duplicates
Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;
Example: SELECT column1 FROM table1 UNION ALL SELECT column1 FROM table2;
Coalesce function in SQL is used to return the first non-null value in a list of expressions.
Coalesce function takes multiple parameters and returns the first non-null value.
It is commonly used to handle null values in SQL queries.
Example: SELECT COALESCE(column_name, 'N/A') FROM table_name;
posted on 20 May 2024
I applied via Referral and was interviewed in Nov 2023. There was 1 interview round.
posted on 21 May 2024
I applied via Company Website and was interviewed in Apr 2024. There was 1 interview round.
Basics of SQL was asked, having good foundation will really help in clearing this round
posted on 6 Jun 2024
based on 1 interview
Interview experience
Software Engineer
19
salaries
| ₹0 L/yr - ₹0 L/yr |
Business Analyst
17
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate Software Engineer
13
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate Business Analyst
12
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Developer
8
salaries
| ₹0 L/yr - ₹0 L/yr |
Moonfrog Labs
Octro
Nazara Technologies
Games2Win