ROUND-1
[ SQL ]
1. Write a SQL query with the following input and output
Input:
num
1
2
3
Output:
1
2
2
3
3
3
2. Write SQL for latest updated price of any product from blinkit darkstore data (data was given) on a particular date. {Same was asked to be written in python as well}
3. Mixed concept of self join, subquery and CTE's {I don't remember the exact question}
[ Puzzle ]
1. How do we measure forty-five minutes using two identical wires, each of which takes an hour to burn? We have matchsticks with us. The wires burn non-uniformly. For example, the two halves of the wire might burn in 10 minutes and 50 minutes, respectively.
2. There are 4 people (A, B, C, and D) who want to cross a bridge at night.
A, B, C and D take 1, 2, 5 and 8 minutes respectively to cross the bridge.
There is only one torch with them, and the bridge cannot be crossed without the torch.
There cannot be more than two people on the bridge at any time, and when two people cross the bridge together, they must move at the slower person's pace. Find the minimum time required to cross the bridge.
3. You are given a normal die and a blank die. (Each die is six-sided and equally likely to show each face). Label the blank die using the numbers 0 to 6 so that when you roll the two die the sum shows each whole number from 1 to 12 with equal chance. You can use a number more than once, or not at all, so you could label the faces 1, 2, 3, 4, 4, 5. But you do have to label all six faces of the blank die.
[ Case ]
1. There are medicine order data of blinkit. How will you label chronic and non-chronic disease medicine from this data only? {There is nothing about the medicine is mentioned in the data like description, patient presciption etc.}
2. I need to open blinkit darkstore in new cities except the current one in India. on what basis should I rank all these cities to get a priority order of cities for blinkit expansion.
ROUND - 2
The Round was majorly business oriented and checked my business data understanding
1. Discussion on Every Line of my CV
2. Difference between percent and percentile, Explain percentile in lay men terms.
3. Can we calculate MAU from DAU?
4. Medium level SQL questions asked to write the same thing using python pandas syntax
5. V-lookup and Sumif function questions of advanced excel
6. What are the features that we need to consider for dividing a city into different zones blinkit Warehouse?
ROUND - 3
It was mostly revolving around my CV, My personality, Previous experiences and what I am aspiring to do in my future?