Interview Guides
You are given nightly usage data from a connected sleep therapy platform. Write a PostgreSQL query to return the users who fall in the top 10% based on their average nightly device usage hours over the last six months. Only include nights within the rolling six-month window, ignore rows where usage hours are NULL, and return each qualifying user's id, full name, average nightly usage, number of nights included, and percentile bucket.
