Birla Institute of Technology, Mesra

Question: 'Estimate the number of cups of tea consumed daily on your university campus.' 1. State clarifying assumptions (campus student population = 6,000; hosteler vs day scholar split = 80/20). 2. Segment by user personas (non-tea drinkers = 30%, light drinkers = 1 cup/day, heavy exam grinders = 3 cups/day). 3. Add faculty and canteen footfall. 4. Sanity check with canteen vendor batch sizes. Interviewers care about structured logic, not the exact number.

I can’t take it anymore. People outside think NIT Warangal is a top-3, Tier-1 institute, but living here is an absolute nightmare. 1. Basic Infrastructure Failures (No tables, no chairs, broken toilets) No Basic Amenities: We haven't even been provided basic study tables and chairs in our hostel rooms. How is a student supposed to study or sit comfortably in their own room? Sanitation Crisis: The hostel toilets are biohazards. Flushes don't work, jet sprays are completely broken, a

Every company asks at least one SQL question in round 1 or 2: 1. 2nd highest salary using `DENSE_RANK()` vs `LIMIT OFFSET` 2. Employees earning more than their managers (self-join) 3. Duplicate emails / usernames (`GROUP BY HAVING COUNT(*) > 1`) 4. Customers who never ordered (`LEFT JOIN WHERE IS NULL`) 5. Cumulative monthly revenue (Window function `SUM() OVER (ORDER BY month)`). Master window functions and self-joins!

When the Nescafe shop owner realized he had zero competition after midnight, he started charging 50 rupees for a single Maggi with two microscopic pieces of capsicum. So 4 guys in Hostel 7 set up an illegal guerrilla Maggi distribution network called 'MaggiExpress' on Telegram with a secret pickup point behind the water cooler. Within one week, Nescafe sales plummeted by 80% and the uncle had to slash prices back to 30 rs with free oregano sprinkles. Free market economics in action.

Hostel 3 AM Maggi Chronicles: Slide 1: Gathering 4 people to contribute 1 packet each Slide 2: The illegal electric kettle humming under a blanket so the warden doesn't hear Slide 3: Realizing nobody has a bowl so we are eating it with an ID card ruler Pure hostel engineering. Best meal of the entire week.