Find weekdays with no timesheet entry
Every consultant is expected to log a timesheet entry for every weekday (Monday to Friday) across March 2026 — weekends are not expected.
For each consultant, find every weekday in that month on which they logged nothing.
Return consultant and missing_date, ordered by consultant then missing_date.
Schema
▸consultants
| consultant | TEXT |
▸timesheet_entries
| consultant | TEXT |
| entry_date | DATE |
Basic
The example input, expected output, and walkthrough for this question unlock with a Basic plan.
Basic
The reference solution and walkthrough for this question unlock with a Basic plan.
See Basic plansRM 25/mo · cancel anytime
Basic
This is a Basic question
Premium practice questions unlock with a Basic plan. The full solution, expected output, and grading are available to Basic members.
RM 25/mo · cancel anytime