Loop Health Interview Questions
The questions to prepare for Loop Health interviews, across all roles. Questions from real interview reports rank first. Updated daily.
Choose the core metrics that best reflect customer health, balancing usage, sentiment, retention, and business outcomes.
Explain how to structure a cohort retention query using cohort assignment, period offsets, and aggregation in PostgreSQL.
Tests your understanding of multithreading fundamentals and common pitfalls.
Evaluates your ability to design a real-time collaborative system with consistent shared state.
Tests design skills for protecting NinjaHoldings services from abuse and overload.
Assesses ability to translate data into operational actions tied to patient experience.
Tests structured troubleshooting and data-driven reasoning for sudden metric changes.
Sign up to see every question
Create a free account to unlock this list and practice real interview questions.
Find each user's longest consecutive login streak by deduplicating login dates and identifying gaps between days.
Didi Chuxing
ByteDanceWrite a SQL query to identify the top 10% of creators based on engagement metrics over the last 30 days. Use the provided creators and creatorengagements ...
TikTokAggregate project outcomes and present a defensible SQL-based business case analysis.
TikTok