SQL · Meta · Hard
Report scope. Build a daily quality-and-engagement report for dating profiles as of the snapshot instant 2025-09-01 00:00:00 UTC. A profile qualifies only when it is still live (is_deleted = 0) and its newest version at or before that instant carries a review marked is_final = 1 with status = 'approved', also recorded no later than the snapshot instant. The newest version is the one with the greatest created_at value at or before the snapshot; when several versions share…
Checking your access…