Mock interview. You're interviewing for a people analytics job. The interviewer explains: "Employees are asked to be in the office 3 days a week. Leadership wants to know how we're doing, and where to follow up."
office_logins has one row per badge swipe, from Monday 5 January to Friday 27 March 2026: 12 working weeks. Some people swipe more than once a day, so count days, not swipes.
"Show each week's office days and the average office days per employee (all 66 employees, including anyone who never came in)."
Expected output
week_start, office_days, days_per_employee (rounded to 2 decimals); 12 rows; sorted by week_startExample of the shape (made-up values):
| week_start | office_days | days_per_employee |
|---|---|---|
| 2026-01-05 | 200 | 3.03 |
Hints, the later steps and the answer come with Pro.
Step 1 of 3
Write your query here. Ctrl + Enter submits.