i
Stanza Living
Filter interviews by
I applied via Job Portal and was interviewed in Feb 2023. There were 3 interview rounds.
There were 3 SQL questions
Q1. Find the second highest transaction I'd
Q2. Find the total transaction amount who signed up yesterday
Q3. How to calculate running sum without using window functions.
Excel question
Q1. How to get the data in pivot format without using pivot table option.
I didn't clear my first round interview
I applied via Referral and was interviewed before Aug 2022. There were 4 interview rounds.
Sql, excel questions were asked
To figure out the red colour car in delhi
I applied via IIM Jobs and was interviewed before Dec 2021. There were 3 interview rounds.
Group by and window functions are used in SQL queries to aggregate data and perform calculations on subsets of data.
Group by is used to group data based on one or more columns and perform aggregate functions on each group.
Window functions are used to perform calculations on a subset of data within a group, without affecting the grouping of the data.
Examples of aggregate functions include SUM, AVG, COUNT, MAX, and MIN.
E...
Top trending discussions
I applied via LinkedIn and was interviewed in May 2023. There were 3 interview rounds.
Send assignment doings MS Excel
I applied via Job Portal and was interviewed before Jun 2022. There were 2 interview rounds.
I applied via Company Website and was interviewed before Feb 2023. There was 1 interview round.
Types of join in SQL include inner join, left join, right join, and full outer join.
Inner join returns only the matching records from both tables.
Left join returns all records from the left table and the matching records from the right table.
Right join returns all records from the right table and the matching records from the left table.
Full outer join returns all records when there is a match in either the left or rig
A left join is used to combine data from two tables based on a common column, including all records from the left table.
Left join returns all rows from the left table and the matching rows from the right table.
It is useful when you want to retrieve all records from the left table, even if there are no matches in the right table.
The result of a left join will have NULL values in the columns from the right table where th...
The number of rows after applying join operations depends on the type of join used and the data in the tables being joined.
Inner join retains only the rows that have matching values in both tables
Left join retains all rows from the left table and the matched rows from the right table
Right join retains all rows from the right table and the matched rows from the left table
Full outer join retains all rows when there is a
VLOOKUP in Excel is used to search for a value in a table and return a corresponding value, while SQL functions like JOIN and WHERE are used to retrieve data from multiple tables based on specified conditions.
VLOOKUP is specific to Excel and works on a single table, while SQL functions can work on multiple tables.
VLOOKUP requires the table to be sorted in ascending order, while SQL functions do not have this requiremen...
I applied via Company Website and was interviewed before Feb 2023. There were 2 interview rounds.
Simple SQL & Excel test
I applied via Naukri.com and was interviewed in Apr 2024. There was 1 interview round.
Test was based on SQL, coding and MCQ. Coding involved nested query.
There are 2 coding challenges and 7 objective questions
based on 3 interviews
1 Interview rounds
based on 4 reviews
Rating in categories
Property Manager
274
salaries
| ₹0 L/yr - ₹0 L/yr |
Cluster Manager
172
salaries
| ₹0 L/yr - ₹0 L/yr |
Resident Manager
104
salaries
| ₹0 L/yr - ₹0 L/yr |
Sales Associate
89
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Associate
75
salaries
| ₹0 L/yr - ₹0 L/yr |
Zolo
OYO Life
Nestaway
CoLive